May 22, 2002 at 2:10 pm
We have scheduled transaction log backup for every 15 minutes and it is running correctly. At one interval, the server event-application log has logged message
"transaction log backup is failed". Subsequent log backups have completed successfully.
What may be the reason for the failture? Whether the subsequent log backup will take care the previous failed backup or it may have any issue?
Please clarify.
Thanks.
ASHOK
ASHOK
May 22, 2002 at 4:36 pm
Nothing in the SQL error log? Any chance ran out of disk space?
Andy
May 22, 2002 at 5:42 pm
Do you mean sql server logs? The backup error is not logged in Sqlserver log or in backup plan history. It is only logged in System event viewer-application log.
The backup destination has more free space.
Thanks!
ASHOK
May 23, 2002 at 5:26 am
Bulk transaction or unlogged events can have this effect. You don't have anything issueing trucate table, bulk insert, or using bcp do you? If so then you will have to runa full backup or differential at that point instead.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 24, 2002 at 12:51 pm
I understand that bulk and unlogged events are not recorded in transaction log. My question is what may be the reason for transaction log backup failure at one interval?
ASHOK
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply