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?

davejal
  • 236
  • 3
  • 17

1 Answers1

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.

Cyberider
  • 69
  • 7