tail-log backups

March 16th, 2007 by Mr.M | No Comments »

I backed up a database on serverA running Yukon (SQL 2005) today and tried to restored it to serverB. I got the err

The tail of the log for the database “dbName” has not been backed up.

Fix is to backup the log file using the WITH RECOVERY option, run your backup, and then restore to the desired server.

Leave a Reply

You must be logged in to post a comment.