Mirroring - Do DB schema changes get updated as well?

  • Hi all

    Just a quick question from a noobie!

    If i have a DB mirrored...if I apply schema changes to a table in the primary mirror db...will the secondary mirror DB get updated? or is it just data that get's mirrored?

    Thanks in advance

  • whatever goes to transaction log gets mirrored. In short, yes schema changes does get mirrored.

  • Yes all schema changes are copied over, just remember that DB Mirroring is on the database level, so any logins, instance level DDL triggers and certicates/master keys etc will not be carried over and will need to be applied manually after failover.

  • [font="Verdana"]Hi,

    Database mirroring will work @ database level only and hence all the changes carried out in the databae will be taken to the mirrored db. If the schema change is @ db level the it will surely copied to the mirror db. Check the below link .

    Database Mirroring Advantages & Disadvantages[/font]

  • many thanks guys...

  • Sorry to jump on someone else's post, but this is the exact information I"m looking for related to encryption and mirroring.

    Based on your post, if my principal database fails and the mirror becomes principal, I would have to reapply the keys and certificates. This would need to be done by restoring from the backed up keys from the principal database, correct?

  • Yes Kwilt, you'll have to set up everything for the encryption to work on the mirror as well.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply