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 | ||||||