SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10069 Visits: 4195
I 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,
GilaMonster
GilaMonster
SSC Guru
SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)

Group: General Forum Members
Points: 218253 Visits: 46278
Someone'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?
http://www.sqlservercentral.com/articles/Recovery+Model/89664/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


sqlfriends
sqlfriends
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10069 Visits: 4195
Thanks 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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)SSC Guru (218K reputation)

Group: General Forum Members
Points: 218253 Visits: 46278
Either 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.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search