Microsoft® SQL Server™ administration applications, and the accompanying services, are designed to assist the system administrator with all administrative tasks related to maintaining and monitoring server performance and activities.
Topic | Description |
---|---|
Starting, Pausing, and Stopping SQL Server | Explains starting SQL Server, and what you need to do before, during, and after you log in. |
Importing and Exporting Data | Describes how to retrieve data from external sources and feed data to other applications. |
Backing Up and Restoring Databases | Describes how to protect and restore data over a wide range of potential system problems. |
Managing Servers | Describes how to register and configure remote and linked servers, add or remove servers, and fine-tune server settings. |
Managing Clients | Describes how to configure a client’s connections with server components and change the default network protocol to meet the needs of your site. |
Automating Administrative Tasks | Describes how to establish which administrative responsibilities will occur regularly, define jobs and alerts, and run SQL Server Agent. |
Managing Security | Describes how to protect and safeguard database access by restricting permissions to include only authorized users. |
Monitoring Server Performance and Activity | Describes how to develop a strategy for ensuring that server and activity performance are at acceptable levels. |
Integrating SQL Server with Other Tools | Describes how to integrate SQL Server with other tools and applications. |
Using the Web Assistant Wizard | Explains how to use the wizard to create Web pages. |
Migrating from Other Products to SQL Server | Explains how to tranfer data and objects from another database management system (DBMS) to SQL Server. |