Home Forums SQL Server 7,2000 General Having Problem in restoring transaction log backup RE: Having Problem in restoring transaction log backup

  • The error is stating that you are not restoring the correct transaction log backup. After restoring your differential backup, you can only restore transaction log backups that follow that differential backup.

    This is just a guess, but are you using devices (single file) to contain your transaction log backups? If so, when (and how often) do you initialize that file? Are you using devices for your full and differentials?

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs