2

I'm trying to restore a backup that is older than the current database.

The restore went ok, but the roll forward didn't giving the following error:

SQL1265N The archive log file ".LOG" is not associated with the current log sequence for database "" on node "0".

I tried to roll forward to an earlier point in time, but it is required to restore to the end of the logs.

The backup is from another server but it's actually a duplicate (so name etc. are the same.)

What steps can I take to resolve this?

1 Answer 1

1

You would have to remove the existing log files from the new server (or better move them somewhere else) and copy the log files from the old server to the new server. It is not possible to rollforward the backup from the old server with the transaction logs from the new server.

Be carefully when you remove the transaction logs from the new server. You wan't be able to rollforward a previous backup taken on the new server.

3
  • Wow, thanks for answering, but I don't work for this company anymore and so cannot confirm if this solution works or not.
    – davejal
    Commented Jan 25, 2022 at 18:10
  • Oh, I didn't realize when you asked this. :-)
    – Cyberider
    Commented Jan 27, 2022 at 6:12
  • yeah ... haha... almost 6 years ago
    – davejal
    Commented Jan 27, 2022 at 12:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.