Administration: How-to Topics (Database Engine)
The topics in this section provide information about how to perform administration tasks related to the SQL Server by using SQL Server Management Studio, Transact-SQL, SQL Server Configuration Manager, SQL Server Profiler, command-prompt utilities, and other tools and wizards.
In This Section
Administering SQL Server Utility How-to Topics
How to create and manage a SQL Server Utility.Managing Services How-to Topics
How to start and stop the Database Engine using SQL Server Management Studio, SQL Server Configuration Manager, and command prompt statements.Server Management How-to Topics
How to manage SQL Server using SQL Server Management Studio, configure SQL Server options, send mail from SQL Server, configure warm standby servers, and configure encryption.Database Engine Connectivity How-to Topics
How to configure connectivity to instances of the SQL Server Database Engine.Backing Up and Restoring How-to Topics (SQL Server Management Studio)
How to use Management Studio to back up and restore databases.Backing Up and Restoring How-to Topics (Transact-SQL)
How to use Transact-SQL to back up and restore databases.How to: Upgrade SQL Server with the Copy Database Wizard
How to use the Copy Database Wizard.Automated Administration How-to Topics (SQL Server Management Studio)
How to define jobs and alerts in SQL Server Management Studio.Automated Administration How-to Topics (Transact-SQL)
How to define jobs and alerts with Transact-SQL stored procedures.Policy-Based Management How-to Topics
How to use Policy-Based Management to manage one or more instances of SQL Server.