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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database mirroring with no Witness

Author  Topic 

nguyenl
Posting Yak Master

128 Posts

Posted - 2009-03-24 : 11:39:35
Hi,

I have 2 servers, Server A and Server B. The Principal is server A. I do not have a witness server. I plan to manually switch over to the the databse on Sever B in case the Principal database fails. To test my setup, I turned off Server A to mimick a "Server Crash". I logged onto Server B to see if I can access the mirror databse and it says "Mirror, Disconnected/In recovery". How can I access it?

Thanks

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-03-24 : 11:47:32
see this:
http://www.mssqltips.com/tip.asp?tip=1701
and:
http://www.mssqltips.com/tip.asp?tip=1564
Go to Top of Page
   

- Advertisement -