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.
| Author |
Topic |
|
sony4
Starting Member
5 Posts |
 Posted - 2008-01-04 : 01:35:48
|
| Could some please explain me how do we hanlde manual fail over in case of high protection database mirroing set up with out any witness server. Lets say the primary database goes down and we have to bring the mirror db up, then first of all we have to restore the mirror db( one in restore mode) with recovery.but is it possible to restore the mirror db with recovery if primary goes down. Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-04 : 09:26:20
|
| Well, First of all you have to restore full backup to Mirrored server in Norecovery Mode and take finally restore transaction log backup to it in Norecovery mode. Then after you configure the mirror ,you can manually failover by pressing failover button.Hope this helps. |
 |
|
|
|
|
|
High protection