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

Mirror failover Expand / Collapse
Author
Message
Posted Tuesday, March 05, 2013 10:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:16 PM
Points: 86, Visits: 351
Hi All,
I have an issue with mirror failover
1. I configured mirroring on 3 databases. if in 3databses one got failover the other two also need to failover to the mirror server can any one know the TSQL command?
please post here..
I have small idea about the query where mirror status is 7 or 8
Post #1426914
Posted Tuesday, March 05, 2013 11:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:16 PM
Points: 86, Visits: 351
No one knows the answer?
Post #1426951
Posted Wednesday, March 06, 2013 4:38 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:16 PM
Points: 86, Visits: 351
Please go through below link
http://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/
Post #1427686
Posted Wednesday, March 06, 2013 9:06 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: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Is this manual or automatic failover?

I dont think if this manual failover then one database failover to mirrored will support for all you need to manually need to failover the rest of DBS.

Incase if you sre setting up the automatic dailover with withness server then if the withness server does not receive the pingdom from the pricipal serevr then it will initiate failove for all the databases which are participating in mirroring.


"More Green More Oxygen !! Plant a tree today"
Post #1427739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse