July 9, 2010 at 3:48 pm
I have an application that has moved to 2008-:w00t:R2 in the past few weeks. I was asked about setting the database up using Mirroring. So I have did some research and have a few questions that I would like ask.
1. When restoring the mirror DB should I use the Restore with NoRecovery? When this is done the DB still shows that it is restoring and from what I read this will be normal.
2. Can I turn on the Mirroring while users are in the application/DB like I can with Log Shipping?
July 9, 2010 at 5:11 pm
Robin Drury (7/9/2010)
I have an application that has moved to 2008-:w00t:R2 in the past few weeks. I was asked about setting the database up using Mirroring. So I have did some research and have a few questions that I would like ask.1. When restoring the mirror DB should I use the Restore with NoRecovery? When this is done the DB still shows that it is restoring and from what I read this will be normal.
yes. also take one tranlog backup post the full backup and restore that with norecovery
2. Can I turn on the Mirroring while users are in the application/DB like I can with Log Shipping?
yes
---------------------------------------------------------------------
July 12, 2010 at 9:03 am
Thanks for the reply back. I will be turning on the mirroring this evening.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply