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

My old mate sp_recompile
12 October 2007 11:33

As soon as i saw the error messages in the logs i thought to myself "Oh my, that did not happen in testing" (ok, maybe it was more colourful than that). We were creating a clustered index on a tiny little table and the index went through fine. However, the application started to generate the message " Could not complete cursor operation because the table schema... Read More...

by ACALVETT | 2 comment(s)

Filed under: SQL 2005, SQL 2000, Tips, System Procedures