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

WMI event for mirroring Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 3:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:59 PM
Points: 86, Visits: 364
Hi Friends,
I have to implement Mirroring on 4 databases.
1. How can I write code for Failover for all databases. If one DB got failover I want it to failover all the databses. For this I want create a WMI event for Each DB can any one know the script please reply me back.

Thank you in Advance
Post #1426484
Posted Monday, March 11, 2013 9:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 381, Visits: 1,855
Please go through this link- answer is here.

http://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/


Is your DBmirroring setup in synchronous mode or asynchronous mode?
Post #1429361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse