SQL DBA Checklist/Activities

Spread the love

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.

Spread the love
Author: OTi
Meet OTi, the brains behind the popular tech blog "OurTechIdeas.com." OTi is an accomplished author, tech enthusiast, and an expert in SQL Server. With over a decade of experience in the tech industry, he has become a trusted voice in the world of database management. OTi's passion for technology began at a young age, and he has been tinkering with computers ever since. He graduated with a degree in Computer Science and has since worked for some of the biggest tech companies in the world. His experience has given him a deep understanding of how technology works and how it can be used to improve our lives.

Leave a Reply

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