InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:53:59 GMT20http://www.sqlservercentral.com/Forums/Topic1392343-391-1.aspxThank you, Sir. Actually Perry's command worked for me.Wed, 05 Dec 2012 20:18:39 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1392343-391-1.aspxApologies, misread the question. Perry's command is what you need.Wed, 05 Dec 2012 04:24:18 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1392343-391-1.aspxIf the principal is down and you want to bring the mirror up you will need to force service using[code="SQL"]ALTER DATABASE mydb SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS[/code]Wed, 05 Dec 2012 02:56:58 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1392343-391-1.aspxActually my Principal server got down. It will take some hours to be ok. That's why I have to use Mirror database to run my application. In Mirror database it is stated as [color="#34c96a"][b]myDB (Mirror, Disconnected/ In Recovery)[/b][/color]. But I configured mirroring with high safety without automatic failover mode. So I have to make Mirror as Principal. But how?I can't do it. Please help me.Tue, 04 Dec 2012 21:52:37 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1392343-391-1.aspxRun this on whichever is the principle at the time:ALTER DATABASE dbname SET PARTNER FAILOVERThey'll need to be synchronized first though.Tue, 04 Dec 2012 04:11:29 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1392343-391-1.aspxDear,I have configured mirroring with high safety without automatic failover mode. For testing purpose I want to failover between Principal and Mirror. Say, Principal server gets down. Now I want to switch role of Mirror to Principal. But how? Please let me know.Imagine, Mirror is now Principal and former Principal Server is live again. At this time I want that former Principal takes the role of Principal and start functioning. But how? please let me know.Regards,AkbarTue, 04 Dec 2012 03:54:47 GMTshohelr2003