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 |
|
GaneshRamanan
Starting Member
40 Posts |
 Posted - 2011-02-18 : 16:04:52
|
| I remove the mirror in the Principal database , but in the mirrored server the database is still in restore state how can i bring the database to online state in mirrored state? can anyone guide meThanks in advance,Ganesh |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-18 : 16:48:13
|
| When you save "removed the mirror" did you suspend mirroring (SET PARTNER SUSPEND) or stop it (SET PARTNER OFF)? If the former, ALTER DATABASE...SET PARTNER RESUME will fix it. If the latter, you may be able to RESUME, but you might have to make a fresh log backup and restore it to the mirror server, then re-establish mirroring. Worst case is you'll have to make a full database backup, then a log backup, and restore both and then rebuild the mirror. |
 |
|
|
|
|
|
Urgent!!! Database Mirroring