Database Engine Administrator InfoCenter

In Microsoft SQL Server 2005, a Database Engine administrator plans and runs the daily operations of instances of the Database Engine in such areas as system availability, performance monitoring and optimization, deployment, upgrades, troubleshooting, and configuration. Small and medium organizations may have only one administrator; larger organizations may subdivide the administrator role into multiple job titles. For more information see Database Engine Developers and Administrators.

To help the administrator of the Database Engine be as effective as possible, the following lists provide links to those topics considered most useful for the maintenance and optimization of instances of the Database Engine.

Note

Database design is classified as a developer activity. For more links related to database design, see the Database Engine Developer InfoCenter.

Concepts Administering the Database Engine Viewing Database Metadata Metadata Visibility Configuration Monitoring Events Documenting and Scripting Databases Scripting Jobs Using Transact-SQL Working with the Database Engine Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views Configuring a SQL Server Installation Automating Administrative Tasks Dynamic Management Views and Functions Query Performance Introduction to Backup and Restore Strategies in SQL Server Optimizing Backup and Restore Performance in SQL Server Optimizing Bulk Import Performance Detaching and Attaching Databases How to: Upgrade to SQL Server 2005 with the Copy Database Wizard How to: Upgrade a Database Using Detach and Attach (Transact-SQL) Integration Services Overview About Bulk Import and Bulk Export Operations Languages Transact-SQL Reference (Transact-SQL) SQL Server Management Objects (SMO) Tools Introducing SQL Server Profiler Database Engine Tuning Advisor Overview Tuning the Physical Database Design Maintenance Plans SQL Server Management Studio Using the sqlcmd Utility

More InformationSQL Server Database EngineInstalling the Database Engine Installing the SQL Server Database Engine Running Setup from the Command Prompt Installing SQL Server 2005 Components Installing SQL Server Analysis Services Installing SQL Server Integration Services Installing SQL Server Reporting Services Security Security Considerations for SQL Server International Considerations Setting and Changing Collations Tutorials and Walkthroughs Database Engine Tuning Advisor Tutorial sqlcmd Utility Tutorial SQL Server Management Studio Tutorial Troubleshooting Troubleshooting an Installation of the SQL Server Database Engine Troubleshooting the Database Engine External Resources SQL Server TechNet