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 |
|
DKnutson
Starting Member
4 Posts |
 Posted - 2009-06-26 : 14:59:45
|
| I've setup a mirrored database on two SQL2005 servers. These are setup with full safety and a witness. I've tested the automated failure and can get it to switch back and forth without a problem. Today I tried to test how to restore the database, but I'm not having any luck.Can someone tell me what steps I need to follow in order to do a restore of a mirrored database. It almost looks like I need to completely tear down the mirror, then restore on both machines, but that can't be correct. (I hope) |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-26 : 15:31:28
|
| No, that sounds to be correct. Keep in mind, when you restore a full database backup, SQL Server does not have any way to tell if this is a former version of the database, or an altogether different database. In short, the logs required to get the mirror up to date simply are not there. |
 |
|
|
DKnutson
Starting Member
4 Posts |
Posted - 2009-06-26 : 15:42:28
|
| Thanks for the response! Having to do that may be a problem - the server will be at the other end of a T1 and the database will be over 30-GB. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-27 : 11:11:13
|
| You can take Database Snapshot and Also use it to restore but won't be point in time. |
|
|
|
|
|
|
Steps to restore DB when mirrored