May 6, 2010 at 4:33 am
On checking the transaction log backup maintenance plan history i found the following error desciption :
"Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
What could be the possible cause for the transaction log failure. After the failure the job was manually triggered and it executed successfully.
May 6, 2010 at 4:44 am
check the error log..
May 6, 2010 at 4:54 am
It's look like your T-log backup gets completed but entry in the msdb database (Backupset table) is failing. Check if the entries of backup's are going into Backupset table or not.
If you taking T-Log backup from maintanance plan and you have choosen to Clean-up history task then there are chances that cleanup history task is locking the entry in msdb.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply