Post reply

How to do the failover in the asynchronous mode of the mirroring

  • August 10, 2010 at 12:47 am

    #225267

    hi all,

    how to do the fail over if we configured the mirroring in asynchronous mode

    regards,

    Anjali.

  • August 10, 2010 at 2:18 am

    #1204546

    how to do the fail over if we configured the mirroring in asynchronous mode

    You need to execute the following code for the failover; however, as the database mirroring session is operating in asynchronous mode, there may be some data loss occurs during the failover.

    ALTER DATABASE [TESTDB] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply