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 04, 2013 3:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:14 AM
Points: 81, Visits: 283
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 229, Visits: 1,062
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