InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:30:09 GMT20http://www.sqlservercentral.com/Forums/Topic1426914-1550-1.aspxIs 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.Wed, 06 Mar 2013 21:06:01 GMTMinazhttp://www.sqlservercentral.com/Forums/Topic1426914-1550-1.aspxPlease go through below linkhttp://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/Wed, 06 Mar 2013 16:38:46 GMTAAKRhttp://www.sqlservercentral.com/Forums/Topic1426914-1550-1.aspxNo one knows the answer?Tue, 05 Mar 2013 11:20:14 GMTAAKRhttp://www.sqlservercentral.com/Forums/Topic1426914-1550-1.aspxHi All,I have an issue with mirror failover1. 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 :-)Tue, 05 Mar 2013 10:03:43 GMTAAKR