O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Basic Duties of a DBA

A SQL Server DBA must wear many hats to provide a full level of service. The requirements for the DBA will vary from company to company depending upon the typical business needs or budget. The DBA might be required to perform all tasks from installation and configuration to performance tuning and guiding purchases. Conversely, the DBA might have responsibility for a single particular task such as managing backups and restores, performance optimization, or ETL tasks.

Whatever your DBA responsibilities, there are some core, basic duties that should become second nature to all DBAs.

Installation and Configuration

The SQL Server DBA is the primary source for completing installations of SQL Server in the environment. Depending on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required