A client’s maintenance plan ran fine, but old backup files were never deleted. The answer was in the documentation. Here is what to check.
SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts. Runtime.Wrapper. IDTSPackageSigning100’ from Assembly
Fix the maintenance plan error in SSMS, could not load type IDTSPackageSigning100, when existing plans run fine but you cannot modify them.
SQL SERVER – FIX Error: Maintenance plan scheduled but job is not running as per schedule
A maintenance plan was scheduled for 10 PM, but the job was not running as per schedule and showed no history. Here is how I found the cause.
SQL SERVER – Unable to Open Maintenance Plan in Management Studio
SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.
Database Maintenance Checklist: Daily, Weekly and Monthly
A database maintenance checklist keeps the dull checks from slipping. This post lists what to check daily, weekly and monthly in SQL Server, with one small read-only query for backups, errors, free space, CHECKDB, statistics, growth, logins and patch level.
Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress
Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.
Ordering a Maintenance Window: Backups, CHECKDB and Index Work
Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.