in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » Maintenance Plans » SQL 2005 (RSS)

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

  • Dotty about maintenance plans

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on 06-22-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

  • SQL 2005 - Maintenance Plans

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on 01-03-2006
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems