December 4, 2012 at 3:54 am
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
December 4, 2012 at 4:11 am
Run this on whichever is the principle at the time:
ALTER DATABASE dbname SET PARTNER FAILOVER
They'll need to be synchronized first though.
December 4, 2012 at 9:52 pm
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.
December 5, 2012 at 2:56 am
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" 😉
December 5, 2012 at 4:24 am
Apologies, misread the question. Perry's command is what you need.
December 5, 2012 at 8:18 pm
Thank you, Sir. Actually Perry's command worked for me.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply