Browse by Tags

All Tags » Deadlock (RSS)
Transaction log backup deadlock
19 February 2008 23:10
Recently we started to see deadlock errors when backing up our transaction logs. The "important" part of the error is shown below. 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 this meant was that the transaction log backup... Read More...
by ACALVETT | with no comments
Filed under: , , , ,
SSMS Log file viewer and Deadlock Graphs
23 January 2008 16:02
Firstly I must say a big thank you to Microsoft for the new deadlock trace flag 1222. Compared to the trace flag output for 1204 & 1205 that you had to use in SQL 2000 it’s a walk in the park to interpret. Anyway, back to the post at hand! This is a quick FYI as i`m not going to go through how to interpret a deadlock graph because Bart Duncan does a fantastic... Read More...
by ACALVETT | with no comments
Filed under: , ,