January 18, 2015 at 10:41 pm
I have 10 databases which are configured as principal in mirroring I need to failover all the databases as part of failover , instead of writing query each database as parner failover, is an script which will generate the databases as principal to failover ?
January 19, 2015 at 4:49 am
ramyours2003 (1/18/2015)
I have 10 databases which are configured as principal in mirroring I need to failover all the databases as part of failover , instead of writing query each database as parner failover, is an script which will generate the databases as principal to failover ?
You'll need to use an ALTER DATABASE ... SET PARTNER FAILOVER
for each principal you wish to failover.
Are any of these mirror sessions asynchronous?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2015 at 10:44 pm
yes the command is used to failover for single db , I need a query to generate the script for individual db's
January 20, 2015 at 4:39 am
Perry Whittle (1/19/2015)
Are any of these mirror sessions asynchronous?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply