In sql server 2005 I have scheduled hourly log backup and night full DB backup. After the night DB backup , the hourly log backup fails for atleast one database with the error , " BACKUP LOG cannot be performed because there is no current database backup. "
I encountered this error some days back. I don't know how similar your issue is with mine.
Let me explain.
I migrated to 2005. Everything went well. Transactional jobs were going good too. But the differential backup failed. Its very logical. As the last full backup I took was on 2000 and when I tried taking differential backup, I encountered this error.
To fix this, I took a fullbackup so that the new sql 2005 server will come to know what is the portion which need to go in differential backup. This solved my problem.
I assume that you have installed all the cumulative sql server patches.
Steps you can take to fix your problem.
1) Check if the fullbackup went successfully? 2) Run the transactional log. 3) If step 2 still fails, please send us the T-sql code to take backup.
Thanks, Sachin
Don't sit back because of failure. It will come back to check if you still available. -- Binu
The Db backups are successfully. When ever the hourly T-Log stops due to the error , that there is no backup of a particular DB. I do that particular database backup and then run the t-log backup. Then it would be sucessfully until , the next night's backups. All the night backup are scheduled at 12.00 AM and hourly Log backups are stopping at 2.00 AM
Hourly Log backup error
Posted - 12/16/2006 : 09:34:15
