Backup - Do you set up a complete Maintenance Plan?
Loading last updated info...
It is surprising how many IT staff create backup plans and then leave it at that. To have a complete maintenance plan, you should also consider the following:
- Checking database integrity
- Shrinking Databases
- Reorganizing Indexes
- Rebuilding Indexes
- Updating Statistics
- Cleaning up old maintenance histories
- Performing automatic backups
- Backing up System databases
- Last but not least - you should regularly check that the maintenance plans have been running successfully. Otherwise, all your backup and maintenance efforts are pointless
This can be found under Management | Maintenance Plans within the database tee in SQL Server.
Figure: SQL Server - A Complete Weekly Maintenance Plan