July 14, 2014

Database Administrator daily tasks

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.

Installing DB software
Creating databases
Performing upgrades of the database and software to new release levels
Starting up and shutting down the database
Managing the database's storage structures
Managing users and security
Managing schema objects, such as tables, indexes, and views
Making database backups and performing recovery when necessary
Proactively monitoring the database's health and taking preventive or corrective action as required
Monitoring and tuning performance