SQL SERVER DBA CHECKLIST

Reading Time: 1 minute

SQL Server DBA Checklist

DAILY Checklist

1. Backups
2. Sql Server Error Logs
3. Windows Event Log
4. Sql Server Agent Jobs
5. Performance Logs
6. Security Logs
7. Storage
8. Corrective Actions
9. Improvements

Fifteen-Day Checklist

1. Backup Verification (Comprehensive)

MONTHLY Checklist

1. Backups Verifications (Simple)
2. Windows, SQL Server or Application Updates
3. Capacity Planning
4. Fragmentation
5. Maintenance
6. Security
7. Shrink databases

 

Leave a Reply

Your email address will not be published. Required fields are marked *