- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
- Agresso AskSSC Assyst Axios Azure Backup Book Review Books Career Certification Cluster Configuration CSV CTE DBCC Denali Deployment Design Disaster Recovery Documentation Education Error Message ETL Execution Plans Full Text Indexes Indexing Installation IT Management Kaseya Kindle Maintenance Maintenance Plans Management Meme Monday Memory Migration Misconceptions Monitoring MSDB Myths Normalization People Performance PowerShell Programming red-gate Restore SQL Agent SQLBits SQL Monitor SQLPrompt SQLSaturday SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQLSouthWest SSMS ssmstoolspack SSRS T-SQL T-SQL Tuesday Tools Training Troubleshooting Un-SQL Friday Upgrade User Group Virtual Machines Windows 2012 WordPress WTF XML
Tag Archives: Maintenance Plans
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 →
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 →
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 →
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 →