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.

Start your free trial