The following sections examine the responsibilities of the database administrator and how they translate to various Microsoft SQL Server tasks.
Installing and Upgrading a SQL Server
The DBA is responsible for installing a SQL Server or upgrading an existing SQL Server. In the case of upgrading a SQL Server, the DBA is responsible for ensuring that if the upgrade is not successful, the SQL Server can be rolled back to an earlier release until the upgrade issues can be resolved. The DBA is also responsible for applying SQL Server service packs. A service pack is not a true upgrade, but an installation of the current version of software with various bug fixes and patches that have been resolved since the product's release.