ananda.murugesan (8/14/2013)
I have doubt.. I have Mirror setup manual failover without witness serverIf Principal server is down due to N/W or H/W issues, In this cause mirror database condition is Restoring only...so I want to make online mirror database which command need to be executed?
Is it correct as below command? only one command
ALTER DATABASE <MIRROR DATABASE> WITH RECOVERY
rgds
ananda
As i said, whether you use synch or asynch mirroring without a witness, if you lose the principal the only way to bring the mirror online is by using
ALTER DATABASE <Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉