Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Mirror DB - Does it update schema changes too?

Author  Topic 

markh8ytr
Starting Member

2 Posts

Posted - 2008-06-30 : 05:46:56
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

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2008-06-30 : 05:59:42
yes it will copy the data as well as schema changes.

-
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu
Go to Top of Page

markh8ytr
Starting Member

2 Posts

Posted - 2008-06-30 : 06:15:21
many thanks!
Go to Top of Page
   

- Advertisement -