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 |
|
shankbond
Starting Member
5 Posts |
 Posted - 2010-06-28 : 07:46:23
|
| Hi,I was trying to do a database mirroring( for learning purposes). But the mirroring process failed.I am currently having sql server 2005 developer edition, installed in physically two different machines.It gives me an error that there is some error : with the network address I have specified.Note: I have created these settings through SSMS.The network address is as TCP://<machine>:5022for both the mirror and principal.Also, if possible can some one please help me restore the mirrored database in the previous state:I mean: I had to restore it with the current back up with recovery on.It is still in Restoring state I hope You get my point.Please reply as soon as possible. Thanksshankbond |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-07-26 : 16:16:41
|
| If you want to recover mirror database, remove mirroring, and on secondary server issue this command:restore database <mirror_database_name> with recovery |
 |
|
|
|
|
|
newbie question related to database mirroring