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

The Job whose owner kept coming back......
30 December 2007 19:25

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 42000] (Error 15404))." So, we went around and updated... Read More...

by ACALVETT | 3 comment(s)

Filed under: Maintenance Plans, SQL 2005, Tips

2005 - Alter failed for server XXX
13 February 2006 18:04

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 for this error so i had to dig out profiler to see what... Read More...

by ACALVETT | with no comments

Filed under: Maintenance Plans, SQL 2005, Tools, Tips