SQL Server DBA Daily task
These are the task list that must be done by a DBA on daily basis.
1) Check System Event Logs and SQL Server Error Logs for unusual events.
2) Verify that all scheduled jobs have run successfully.
3) Confirm that backups have been made and successfully and moved to the backup storage or secure location.
4) Monitor disk space to make sure SQL Servers will not run out of disk space.
5) Periodically monitor performance of database and system using both System Monitor and SQL Server Profiler.
6) Monitor and identify blocking issues.
7) Keep a log of any changes you make to servers, instance setting, database setting and monitoring script.
8) Create SQL Server alerts to notify you of problems, and e-mailed to you. Take action as needed.
9) Regularly restore backups to a test server in order to verify that you can restore them.