Managing Servers
Server management in Microsoft SQL Server 2005 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
| Topic | Description |
|---|---|
Contains information about registering the SQL Server Database Service. |
|
Covers administrative operations that can be performed concurrently. |
|
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. |
|
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. |
|
Contains information about using SQL Server to send and receive e-mail messages. |
|
Contains information about advanced server configuration options for optimizing performance under specialized conditions. |
See Also
Concepts
Managing Memory for Large Databases
Using AWE
Understanding Non-uniform Memory Access
Other Resources
Connecting to the SQL Server Database Engine
Advanced Database Engine Details