June 30, 2008 at 3:48 am
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
June 30, 2008 at 4:45 am
whatever goes to transaction log gets mirrored. In short, yes schema changes does get mirrored.
June 30, 2008 at 7:27 am
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.
July 1, 2008 at 1:47 am
[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]
Regards..Vidhya Sagar
SQL-Articles
July 1, 2008 at 1:55 am
many thanks guys...
June 2, 2010 at 10:04 am
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?
June 2, 2010 at 10:24 pm
Yes Kwilt, you'll have to set up everything for the encryption to work on the mirror as well.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply