locked
Connection between Principal and Mirror servers RRS feed

  • Question

  • Hi guys, right now I am facing this scenario several times and I wonder why it can be happen. Both SQL servers are in Enterprise SP1 edition. The mirroring setup can be work fine to me. Once my principal get attacking by DDOS, then mirroring session change the status to 'DISCONNECTED'.  However, after DDOS attack solved and line connection gets back on the principal server, the mirroring session still remain to the status ('DISCONNECTED'). If I restart the SQL services on principal server or mirror server, then only the mirroring session change to 'SYNCHRONIZING' status. Does anyone faced this happen before? I need some assistance on it and hope able to get any explanation or solution from you guys. Thanx and have a nice day.

     

    Best Regards,

                Hans

    Monday, April 2, 2007 3:02 AM

All replies

  • Are the SQL server services set to BOOT or enabled to restart on the failure.

    Also chekc the SQL server error log in this case.

    Sunday, April 15, 2007 7:01 PM