Server management in Microsoft SQL Server comprises a wide variety of administration tasks.
In most cases, you do not need to reconfigure the server. The default settings for the server components allow you to run SQL Server immediately after it is installed. However, server management is necessary when you want to add new servers, set up special server configurations, change the network connections, or set server configuration options to improve SQL Server performance.
In This Section
Contains information about registering the SQL Server Database Service.
Managing the Database Engine Services
Contains information about managing the Windows services that implement an instance of the Database Engine, such as stopping and starting the services.
SQL Server Configuration Manager
Contains information about using the SQL Server Configuration Manager to configure the Windows resources used by SQL Server, such as network protocols and service accounts.
Connecting to the SQL Server Database Engine
Contains information about how users and applications connect to an instance of the Database Engine.
Contains information about using logon triggers to perform tasks such as auditing and controlling connections to an instance of the Database Engine.
Concurrent Administrative Operations
Covers administrative operations that can be performed concurrently.
Using a Dedicated Administrator Connection
Describes making emergency connections.
Contains information about configuring servers to exchange data through linked server connections. Linked servers allow you to execute distributed queries and distributed transactions on OLE DB data sources across an enterprise.
Configuring Remote Servers
Contains information about configuring servers to exchange data through remote server connections. Remote servers allow you to use one instance of SQL Server to execute a stored procedure residing on another instance of SQL Server.
Setting Server Configuration Options
Contains information about advanced server configuration options for optimizing performance under specialized conditions.
Using Warm Standby Servers
Contains the steps to bring a standby server online.
Managing Metadata When Making a Database Available on Another Server Instance
Contains information about how to manage metadata when you use database mirroring, log shipping, or move a database to another instance of SQL Server.