In addition to the Application / File Server maintenance tasks:
Daily Maintenance Tasks
- Monitor application, server, and agent logs. Configure alerts for important errors that aren’t configured for alert notification
- Check for performance and error alert messages.
- Monitor job status, particularly jobs that back up databases and perform replication.
- Review the output from jobs in the job history or output file, or both.
- Back up databases and logs (as necessary and if not configured as automatic jobs.)
Monthly Maintenance Tasks
- Monitor server performance, tweaking performance parameters as necessary to improve response time.
- Manage logins and server roles.
- Audit server, database, and object permissions to ensure that only authorized users have access.
- Review alert, job, and operator configurations.
Periodic Maintenance Tasks
- Back up the SQL Server Registry data.
- Update the Emergency Repair disk.
- Update server documentation
