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 | 8 comment(s)

Filed under: Maintenance Plans, SQL 2005, Tips

Dotty about maintenance plans
22 June 2007 17:36

I went to remotely edit a maintenance plan the other day and found it took a long time to open any of the objects in the plan. I also found that I was getting errors when clicking the drop down to select a database. The reason for the problem was that the local server connection embedded in the maintenance plan had the server name defined as "." rather than an... Read More...

by ACALVETT | with no comments

Filed under: Maintenance Plans, SQL 2005

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

SQL 2005 - Maintenance Plans
03 January 2006 18:24

I made a decision that to really get things going and identify "trouble spots" that i would continue my quick win approach. So basically i`m working through installing and configuring our test SQL 2005 box following our SQL 2000 install instructions. Through out this approach i`m documenting and making necessary changes so i can have first drafts of install docs... Read More...

by ACALVETT | with no comments

Filed under: Maintenance Plans, SQL 2005