Home Forums SQL Server 2008 SQL Server 2008 High Availability Suspending Database Mirroring RE: Suspending Database Mirroring

  • December 27, 2012 at 8:53 am

    #1571893

    Preet_S (12/20/2012)

    Hi All

    Does anybody know if suspending db mirroring prevents automatic failover should the primary fail ?

    I know that Suspending stops transactions being sent to the mirror and the principal runs exposed, but would the witness still attempt to failover should the primary become unavailable ?

    Thanks in advance

    Preet

    I believe, suspending mirroring means, it's paused somehow, can be done manually or can cause by many different things.....It can be due to network failure, or space issues.

    Does anyone know what else can cause the mirroring to be in a suspended state?

    SueTons.

    Regards,
    SQLisAwe5oMe.