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: Friday, November 11, 2016 11:25 PM
Points: 547, Visits: 3,044
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: Tuesday, November 15, 2016 3:41 AM
Points: 103, Visits: 1,267
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