SQL DBA Checklist/Activities

Daily Checklist

1) Backups
2) SQL Server Error Logs
3) SQL Server Agent Jobs
4) HA or DR Logs
5) Shift Handover (New/Pending Tickets)
6) Implementing planned Change Tickets

Weekly Checklist

1) Integrity Checks (DBCC CHECKDB)
2) Index Maintenance
3) Updation of Statistics
4) Cycle SQL Server Error Logs
5) Reporting of Tickets Handled
6) Planning of Change Tickets
7) If any Weekly Meetings, then Prepare MOM (Minutes of Meeting).
8) Attending CAB Meetings and taking approvals for Changes.

Monthly Checklist

1) Backup Validation Test.
2) Capacity Planning: Disk, CPU, and Memory.
3) Plan if any Security Patches or Critical Hotfixes are released.
4) Report on overall Uptime/Downtime

Quarter Checklist

1) DR Test
2) Check who all have SYSADMIN permission and remove unwanted logins having this permission.
3) SOX Audit Standard

Yearly Checklist

1) Licensing Validation (if it is Volume Based Licensing)
2) Service Pack validation and applying newly released SPs.

Facebook Comments Box
Please like or share this post if you found it helpful, thank you.
Share on Facebook
0Tweet about this on Twitter
Share on LinkedIn
Email this to someone
Print this page


Leave a Reply

Your email address will not be published.