Error while starting the Mirrioring

  • The remote copy of database "billing" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)

    Any Help is apprecated:-)

  • try taking a log backup of the primary, then apply that to the mirror with norecovery. Then try to initiate mirroring.

    ---------------------------------------------------------------------

  • george sibbald (9/27/2011)


    try taking a log backup of the primary, then apply that to the mirror with norecovery. Then try to initiate mirroring.

    also any log backups that have been carried in between taking the original backup and trying to start the mirroring

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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