Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Mirroring failover Expand / Collapse
Posted Wednesday, February 13, 2013 5:28 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, September 24, 2016 4:33 PM
Points: 546, Visits: 3,037
Akkare (2/11/2013)
How many databases we can put in mirroring

Microsoft suggests 10 databases to be mirrored in a single instance, but I have seen more. I guess there will be some performance degradation if there are more than 10.

Also if automatic failover happens all db failover start same time ?

Regarding auto failover, it's depends on which database has issues with mirroring.....if you are asking about a scenario where the whole instance going down and each of the mirroring failover to mirror side.....then, I still think it will failover one by one. I did not encounter this of now.


Post #1419779
Posted Monday, March 11, 2013 10:05 AM


Group: General Forum Members
Last Login: Monday, October 24, 2016 11:40 AM
Points: 101, Visits: 1,248
I have come across the below nice tutorials.


Automatic failover failovers all the principal databases to mirror server .

Post #1429370
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse