Browse by Tags

Transaction log backup deadlock

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...

Posted to Andrew Calvett (Weblog) by ACALVETT on 02-19-2008
The Job whose owner kept coming back......

I thought i would share this little quirk about the SQL Agent jobs for maintenance plans. One of our members of staff had left and we had the usual case of a few jobs failing with: "Unable to determine if the owner (DOMAIN\xxx) of job <JOB_Name> has server access (reason: error code 0x534. [SQLSTATE...

Posted to Andrew Calvett (Weblog) by ACALVETT on 12-30-2007
2005 - Alter failed for server XXX

Thats exactly what i thought!! What the hell does that mean? Well, for me this occured in the context of running the maintenance plan integrity check task. It had been running fine for weeks but suddenly boom every time it ran it would fail with "Alter failed for server XXX". There was no obvious reason...

Posted to Andrew Calvett (Weblog) by ACALVETT on 02-13-2006

Page 1 of 1 (3 items)

SQL Server Community Blogs