Stop the Hollyweb! No DRM in HTML5.   

Thursday, May 12, 2011

Idera's SQLsafe Restore Error "too recent to apply to the database"

Last week, my manager came to me and asked if I could perform our first restore since installing the new SQLsafe Backup and Recovery software. Because I was the one that pushed for SQLsafe to take over as our Backup and Recovery solution for all production SQL Servers, I was more than happy to show off SQLsafe's ease of use in restoring databases. I select the point in time that I wanted to restore to and clicked NEXT.

I was expecting for the database to be restored in no time, but instead, and with horror written all over my face, I received the following error message in the "Result Text" with a BIG RED "Error" Progress indicator next to my Restore status.

-------------------------------------------- snip -------------------------------------------

<!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE

" Server instance: INSTANCE/NAME, Database: mas500_pl

The log in this backup set begins at LSN 94000000227900001, which is too recent to apply to the database. An earlier log backup that includes LSN 94000000221200001 can be restored.

RESTORE LOG is terminating abnormally."

Normal 0 false false false EN-US X-NONE X-NONE

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

With embarrassment, I turned to my manager and told him that I would call Idera's support staff and get help with restoring the database. I called the support number and got routed to a voice mailbox. However, within just a few minutes, I got a call back from Carl at Idera's Customer Support. I explained to him the issue I was having and after some brief research on his part, he said based on the message I was receiving that it looked like another backup had been done and that the SQLsafe backup that I was attempting to use was not the most current.

I then opened SSMS and started the restore database wizard. I selected the database that I wanted to restore and then clicked file and add to browse to the folder. Then SURPRISE! The default backup folder appeared with recent backups of the database that I was attempting to restore.

I then clicked on the SQL Server Agent and found a Full Backup job scheduled to run every Sunday at 2:00 am which was after the SQLsafe Full backups.

To restore the database, I first had to restore the native Full backup from Sunday morning with the following sql script;

RESTORE DATABASE [mas500_pl]

FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BACKUP\mas500_pl_db_201105010200.BAK'

WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10

GO

Next I opened SQLsafe and restored each Differential, one at a time, with "Force restore", "Ingnore Checksum Errors", and with non-recovery, "Not accessible", until the last Differential. For the last Differential, I restored it with recovery or "Fully accessible".

So a BIG Thank You goes out to Carl at Idera's Customer Support!

2 comments:

  1. Why did you have to apply ALL diffrential backups, and not just the last one? Diff backups are cumulative....

    ReplyDelete
  2. Not sure. I think at the time, I wanted to apply them one at a time to see if I got any more errors. This was the first time we had used SQLsafe.

    ReplyDelete