Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failover Problem Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 3:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
Dear,

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,
Akbar
Post #1392343
Posted Tuesday, December 4, 2012 4:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 1,976, Visits: 3,280
Run this on whichever is the principle at the time:
ALTER DATABASE dbname SET PARTNER FAILOVER

They'll need to be synchronized first though.
Post #1392348
Posted Tuesday, December 4, 2012 9:52 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
Actually 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 myDB (Mirror, Disconnected/ In Recovery). 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.
Post #1392781
Posted Wednesday, December 5, 2012 2:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 6,351, Visits: 13,680
If the principal is down and you want to bring the mirror up you will need to force service using

ALTER DATABASE mydb SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1392867
Posted Wednesday, December 5, 2012 4:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 1,976, Visits: 3,280
Apologies, misread the question. Perry's command is what you need.
Post #1392910
Posted Wednesday, December 5, 2012 8:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 3, 2014 4:04 AM
Points: 203, Visits: 500
Thank you, Sir. Actually Perry's command worked for me.
Post #1393300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse