Post reply

differ between SET PARTNER FAILOVER vs SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

  • November 10, 2011 at 12:17 am

    #390821

    Hi,

    ALTER DATABASE MyDB SET PARTNER FAILOVER

    ALTER DATABASE MyDB SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    Both commands are to start the principle server from mirror server, whenever principal server goes down.

    SET PARTNER FAILOVER (In mirror server)

    1. Required to in master database context

    2. Safty FULL by default

    3. No loss for data due to committed TLog at mirror server.

    FORCE_SERVICE_ALLOW_DATA_LOSS (In mirror server)

    1. there is chance to data loss due to uncommitted Tlog at mirror server.

    2. ?

    please tell me, what is the main difference between these two command?

    thanks

    ananda

  • November 10, 2011 at 4:28 am

    #1405625

    Hi Ananda,

    Without looking it up, I believe SET PARTNER FAILOVER is only allowed when the mirror DB is marked as being synchronised with the principal DB, i.e. all logs from principal have been applied to the mirror, so there's no danger of data loss.

    FORCE ALLOW_DATA_LOSS can be used to bring the mirror online but with the knowledge you may lose data if the whole log hasn't been replayed at the mirror.

    I think there may also be some restriction on which can be used depending on whether you're using high performance or high safety mode for mirroring.

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

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