Friday, April 20, 2007

BACKUP LOG cannot be performed because there is no current database backup

I was getting this message when trying to use a script to back up my database: "BACKUP LOG cannot be performed because there is no current database backup". My searching lead me to this link:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=243166&SiteID=1. where someone else was having the same issue.

The problem happens when you change the database to simple to truncate the log, then back to full recovery. You have to do a manual full backup before you can do a log back up again.

I had gone to simple recovery in an attempt to shrink a log file that was not being maintained.

5 comments:

Chuck said...

Thanks Kevin! This helped out a bunch today.

Ryan said...

Thanks for posting this, it saved the day and kept me from having to open a Netbackup case with Symantec.

Anonymous said...

Thanks for posting this. It solved my issue without having to contact NetBackup.

Thank you.

G

Anonymous said...

Great info, thanks. This was the problem I experienced. I found your site with a Google search so mission accomplished.

Anonymous said...

Thanks Kevin!!