0 out of 1 rated this helpful - Rate this topic

Administration: How-to Topics (Database Engine)

SQL Server 2008 R2

SQL Server 2008

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.

Other Resources

Designing and Implementing Structured Storage How-to Topics

Performance Monitoring and Tuning How-to Topics

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD