December 14, 2014 at 11:45 pm
i have more than 20 databases which are configured as primary databases in high availability . I need to failover those databases in ones , can any one send the query of all the databases which are primary to failover in mirroring ?
December 15, 2014 at 5:55 am
Manual or automatic failover are not available for asynch mirror sessions, do you have any?
Where asynch is in force you'll need to set Safety on, run from the principal
ALTER DATABASE ... SET PARTNER SAFETY FULL
When synchronised you may then manually failover
ALTER DATABASE .... SET PARTNER FAILOVER
If you need to switch back to asynch you must use
ALTER DATABASE ... SET PARTNER SAFETY OFF
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply