Tag Archives: Maintenance Plans

Agresso Database Servers – Maintenance Checklist

Posted on November 16, 2010 by

This is some information that was not made available to us, the DBA team, on a site I worked at recently.  I suspect that I was not in a unique situation, so I’m providing the DB Server parts of those … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

On master4IDR.ckp, Maintenance Plans, Default Backup Directory and SQL Server Configuration

Posted on November 9, 2010 by

We were going through a process of standardising SQL Server 2000 & 2005 maintenance plans, in this case to put all the backups onto a new drive, out of the way of everything else… So far so good.  Create MP … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged | Leave a comment

SQL Server 2005 RTM Maintenance Cleanup FAIL

Posted on October 18, 2010 by

A recent question on AskSSC reminded me of a little issue affecting SQL Server 2005′s maintenance plans; specifically, the Maintenance Cleanup task. Those of you (un)lucky enough to still be running SQL 2005 RTM may well be aware of this, … Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | Leave a comment