July 10, 2014

SQL DBA Checklist

Following can be SQL DBA Checklist on daily,weekly and monthly basis.

1.SQL DBA daily checklist can include Database backup status, Database integrity checks, failed jobs.

2.Weekly checklist can include index reorganization, update stats etc .

3.Monthly checklist can include Restoration drill for critical databases to ensure backup's availability in case of any unusual happening etc.these are general points.although it depends on current environment and issues how you define your checklist as a DBA.

No comments:

Post a Comment