My client ran a new Maintenance plan for full and log backups and it failed at once. The reason was two subplans in one plan. Here is how to run them.
Error 0x80040E4D: SaveToSQLServer Fails With Login Failed for sa
Error 0x80040E4D stopped a client from saving a maintenance plan, with Login failed for user sa at the end of the message. The sa login was locked out by another maintenance plan that still used an old password. Windows authentication worked in the meantime.
SQL SERVER – Maintenance Plan – Backup Files Not Getting Deleted
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.