SQLServerCentral.com / SQL Server 2008 / SQL Server 2008 Administration / BACKUP LOG cannot be performed because there is no current database backup. / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 15:14:08 GMT20RE: BACKUP LOG cannot be performed because there is no current database backup.http://www.sqlservercentral.com/Forums/Topic1464788-1550-1.aspxEither the database was switched to simple recovery or the log was truncated explicitly (which isn't possible on SQL 2008) or the database was reverted to a snapshot. That's about the only things that will break the log chain and have SQL know about it.Tue, 18 Jun 2013 11:26:25 GMTGilaMonsterRE: BACKUP LOG cannot be performed because there is no current database backup.http://www.sqlservercentral.com/Forums/Topic1464788-1550-1.aspxThanks that is what I suspected too.But I did a readerror_log 'recovery' and found that was a week ago.The change is a bulk-logged backup.But the full backup is on most recent sunday.Tue, 18 Jun 2013 11:19:57 GMTsqlfriendsRE: BACKUP LOG cannot be performed because there is no current database backup.http://www.sqlservercentral.com/Forums/Topic1464788-1550-1.aspxSomeone's run a switch to simple recovery and back to full since the last full/diff backup. It'll be logged in the error log.p.s. Are you sure you want those DBs in bulk-logged recovery all the time?[url]http://www.sqlservercentral.com/articles/Recovery+Model/89664/[/url]Tue, 18 Jun 2013 11:10:00 GMTGilaMonsterBACKUP LOG cannot be performed because there is no current database backup.http://www.sqlservercentral.com/Forums/Topic1464788-1550-1.aspxI have a vendor's production MicroTel.It has 3 databases. They are all at bulk-logged recovery mode.I setup a maintenanance plan to do full at weekend and every day a differential, and every 3 hours a transaction log backup.I got a failed error:BACKUP LOG cannot be performed because there is no current database backup.I do see it has a full backup and a differential before the transaction log backup, why it said no current backup?I can also verify it has a full backup by using restore the database from SSMS, I see it listed the most recent full back up and differential backup.THanks,Tue, 18 Jun 2013 10:46:51 GMTsqlfriends