Tag Archives: Maintenance Plans

Book Review – “SQL Server Transaction Log Management” by Tony Davis and Gail Shaw

Posted on May 21, 2013 by thomasrushton

A couple of questions and comments on the Ask.SQLServerCentral.com website have shown some misunderstanding about the use of SQL Server’s Transaction Log files. At about the same time, I was approached by Red Gate as part of their Friends programme … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , , , , , , | 1 Comment

Agresso Database Servers – Maintenance Checklist

Posted on November 16, 2010 by thomasrushton

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 thomasrushton

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 thomasrushton

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