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 |