locked
An error occured while starting mirroring RRS feed

  • Question

  • An error occurred while starting mirroring.

    Additional information:

    Alter failed for Database "besmgmt" (Microsoft.sqlserver.smo)

    An exception occurred while executing a Transact-SQL statement or batch.

    (Microsoft.SqlServer.ConnectionInfo)

    Database mirroring cannot be enabled because the "besmgmt" database may have bulk logged changes that have not been backed up. The last log backup on the principal must be restored on the mirror (Microsoft SQL server, error: 1475)

    Already referred below steps but restore is not working

    To start the synchronization successfully follow the next steps:

     

    1. Principal Instance - Take a full backup and a log backup as well

    2. Copy the full/log backups from Principal Instance to Mirror instance

    3. Mirror Instance - Restore with NORECOVERY option the full backup

    4. Mirror Instance – Apply the log backup

    5. Principal Instance - Start synchronization


    Anil Kumar (MCITP)

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Sunday, June 23, 2013 2:51 AM

Answers

  • It didn't worked out.

    We logged a call with MS.

    We took the latest Database backup & transaction log backup from principal sql

    copied to the mirrored sql server

    restored database using over ride option with no recovery

    again restore transaction backup using no recovery option

    then started configuring mirror sql

    tested the failover.. it worked.

    Thanks for the assistance Uri Dimant


    Anil Kumar (MCITP)

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Monday, June 24, 2013 11:17 AM

All replies