Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Mirroring failover Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2013 5:28 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, December 5, 2014 8:02 PM
Points: 422, Visits: 2,662
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 scenario....as of now.

Regards,
SueTons.




Regards,
SQLisAwe5oMe.
Post #1419779
Posted Monday, March 11, 2013 10:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:36 AM
Points: 102, Visits: 1,076
I have come across the below nice tutorials.

Refer http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx

Automatic failover failovers all the principal databases to mirror server .


Regards,
Kumar
Post #1429370
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse