Change the schema of a mirrored database

GregP55305

Simple question, I hope. I need to add a column to a table of a database that is mirrored. How do I have to do that Do I need to stop mirroring Is it sufficient to simply pause mirroring If I make the change on the principal db, what do I need to do the make the same change on the mirror

Thanks,

Deepak Rangarajan

Greg,

You don't need to stop the mirroring, you can perform any changes in the principal db and it will automatically get reflected in the mirror db......you can verify the same as follows,

1. add any column in the principal db and it will get reflected to mirror db automatically then after 5 minutes

2. in the mirror db take a database snapshot and just query through the table you can see the column which was added....

GregP55305

Is the same true for add/altering stored procedures

Deepak Rangarajan

any changes you make in the principal database will get reflected just check and see by creating database snapshot........

Vishal Gandhi

All these commands TSQL DDL , DML etc are logged in Transaction Log and in Database Mirroring the Logs record are transferred. Even Replication commands like Create Publication etc are transferred.

SteveJC

Also remember; a Principal database can only use the Full Recovery model which means all operations are fully logged.