|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: 2 days ago @ 10:14 PM
Points: 82,
Visits: 284
|
|
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
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 229,
Visits: 1,065
|
|
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?
|
|
|
|