is there any way to check if the mirror is caught up to recent changes before issuing the failover command?

  • When i try to execute the statement "ALTER DATABASE <DBNAME> SET PARTNER FAILOVER" , i am getting error stating that "the mirror server is not caught up to the recent changes, unable to failover" . After waiting for some time, it performs failover. Is there any way to check if the mirror is caught up to recent changes before issuing the failover command?

  • Run ALTER DATABASE <dbname> SET PARTNER SAFETY FULL to synchronize the databases before failing over.

    Verify synchronization with:

    SELECT

    sd.Name,

    dm.*

    FROM

    sys.database_mirroring dm JOIN sysdatabases sd ON dm.database_id = sd.dbid

    Dan

  • i checked the mirroring state before issuing the failover command. It was showing "SYNCHRONIZED". But when i issue the failover command, i am getting an error tha says mirror is not caught up to recent changes. After waiting for some time and reissuing the command, failover is taking place

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

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