Summary
The role of the database administrator is very important in an organization. The job can be challenging and exciting. If you are a DBA or want to be a DBA, remember that it is important to constantly study SQL Server and database tools. Become certified and practice your backup and recovery procedures. The following is a list of the many duties and responsibilities of a DBA:
Installing and upgrading SQL Server
Applying SQL Server service packs
Monitoring the database server's health and tuning it accordingly
Using storage properly
Backing up and recovering data
Managing database users and security
Establishing and enforcing standards
Performing data transfer
Setting up and maintaining data replication
Data warehousing
Setting up server scheduling ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.