February 8, 2012 at 9:31 am
Wanted to use mirroring for a scenario where we need to make database changes (add tables, change schema, change SP's, etc.) to a Production database without customer downtime by making changes to Mirror database first then switch it to be the Principal and let mirroring copy the changes back to old Principal without any downtime.
But if I'm not mistaken (hoping I am) the Mirror database is NOT online until it becomes the Principal, so does that mean I can not do anything with it till then?
If so, what other solution would be more appropriate?
Thank you,
February 8, 2012 at 9:38 am
Yes you are right, you cannot make changes to the Mirrored DB until it is the Principal, so your plan to setup DB Mirroring for making changes to databases (add, modify tables, sprocs) would not be good idea.
I guess that should all be done on DEV, QA systems before moving to Prod (I hope you know it and are already doing it that way)..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2012 at 9:45 am
Thank you for your response, and yes we do have QA, DEV tiers :-). Is there a way to do this? Being able to switch between two copies of the same database at will?
February 8, 2012 at 9:51 am
I am not aware of any out of the box mechanism / feature. All I can think of is having another copy of the table (with _1 added at the end) and test it using a modified (newer) version of the SProc (again with _1) and test if the functionality works as expected and switching all of them as a single set using sp_rename..
Again this is my thought, after you requested, so I haven't had done that earlier and would need a lot of meticulous testing (since it would be on the Production Environment)...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 9, 2012 at 8:25 am
The mirrored database is in resttoring mode and you cannot make changes.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply