Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-12-16 : 09:34:15
|
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. "This happens both on the prod and test servers.what might be causing this error.Thanks |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-16 : 09:58:23
|
all your db's are succefully backed up?Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-12-16 : 10:16:32
|
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, SachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-12-16 : 12:38:07
|
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 AMThanks |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-12-16 : 12:40:57
|
I am using the Transcation Log task provided in the maintenance plan.Or should I use any other T-sql instead of the wizard.Thanks |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-12-16 : 15:00:49
|
Are u truncating the logs? I am dead sure that the problem is with ur maintainance plan.Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-12-16 : 15:33:21
|
yes , I truncate the logs in my daily maintenance plan after the db full backup is completed.so is that the problem.Thanks |
|
|
|
|
|