Geeks With Blogs
Ben Adler's Development Posting solutions as I find them

I was working locally and trying to restore a database backup from the server for development purposes. I was receiving this error when I tried to restore and overwrite an existing database:

The tail of the log for the database "%ls" has not been backed up. Use BACKUP LOG WITH NORECOVERY to back up the log if it contains work that you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

An easy fix is to click on the Options page and click 'Overwrite the existing database (WITH REPLACE).

More info here: http://msdn.microsoft.com/en-us/library/bb283410.aspx

 

 

Posted on Wednesday, September 14, 2011 3:59 PM SSMS | Back to top


Comments on this post: The tail of the log for the database "%ls" has not been backed up.

# re: The tail of the log for the database "%ls" has not been backed up.
Requesting Gravatar...
Why do you add "if you aren't too concerned about backups" ? Are we going to lose something required to restore other existing backups of that database later if required ?

V.
Left by vletroye on Sep 07, 2012 9:32 AM

Your comment:
 (will show your gravatar)


Copyright © BenAdler | Powered by: GeeksWithBlogs.net