SQL Server Performance Forum – Threads Archive
Manual Failover
I’ve set up a test mirrored database with the following steps:<br />– created endpoints<br />– backed up Primary database<br />– restored with no recovery on Mirror<br />– Set partner: ALTER DATABASE test <br /> SET PARTNER = ‘TCP://instance<img src=’/community/emoticons/emotion-4.gif’ alt=’![Stick Out Tongue :p :p](styles/default/xenforo/smilies/tongue.png)
Have you checked the log on mirror server and see whether the REDO log has completed the logs restore and no pending on SEND queue. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Thank you for your reply. My problem was that the customer told me that he had stopped the services on the Principal when I tried to force the manual failover, but the instance was still available. Once I shutdown the Principal, everything worked as expected. Thanks for the idea, though!
For a failover initiate you have to be ensure no longer transactions are pending, it will take more time.
Check thishttp://msdn2.microsoft.com/en-us/library/ms186348.aspx for more information,. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>