Browse by Tags

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: Maintenance Plans, SQL 2005, Tips, System Procedures, Deadlock

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: SQL 2005, Tips, Deadlock