Table of contents
- Administering SQL Server Overview
- Starting, Pausing, and Stopping SQL Server
- Failover Clustering
- Importing and Exporting Data
-
Backing Up and Restoring Databases
- Designing a Backup and Restore Strategy
- Using Recovery Models
- Backup and Restore Operations
- Managing Backups
- Backing Up and Restoring System Databases
- Handling Large Mission-Critical Environments
- Copying Databases to Other Servers
- Using the Copy Database Wizard
-
Managing Servers
- Registering Servers
- Assigning an sa Password
- Managing AWE Memory
- Configuring Network Connections
- Configuring Linked Servers
- Configuring Remote Servers
- Using Standby Servers
- Log Shipping
- Concurrent Administrative Operations
- Managing SQL Server Messages
- SQL Mail
-
Setting Configuration Options
- affinity mask Option
- allow updates Option
- awe enabled Option
- c2 audit mode Option
- cost threshold for parallelism Option
- cursor threshold Option
- default full-text language Option
- default language Option
- fill factor Option
- index create memory Option
- lightweight pooling Option
- locks Option
- max degree of parallelism Option
- max text repl size Option
- max worker threads Option
- media retention Option
- min memory per query Option
- nested triggers Option
- network packet size Option
- open objects Option
- priority boost Option
- query governor cost limit Option
- query wait Option
- recovery interval Option
- remote access Option
- remote login timeout Option
- remote proc trans Option
- remote query timeout Option
- scan for startup procs Option
- Server Memory Options
- set working set size Option
- show advanced options Option
- two digit year cutoff Option
- user connections Option
- user options Option
- Managing Clients
- Automating Administrative Tasks
-
Managing Security
- Security Architecture
- Planning Security
- Security Levels
- Creating Security Accounts
- Managing Security Accounts
- Managing Permissions
- Advanced Security Topics
- Auditing SQL Server Activity
-
Monitoring Server Performance and Activity
- Evaluating Performance
- Choosing a Monitoring Tool
-
Monitoring with SQL Profiler
- SQL Profiler Keyboard Shortcuts
- SQL Profiler Terminology
- SQL Profiler Scenarios
-
Monitoring with SQL Profiler Event Categories
- SQL Profiler Event Classes
- SQL Profiler Data Columns
- Cursors Event Category
- Database Event Category
- Errors and Warnings Event Category
- Locks Event Category
- Objects Event Category
- Performance Event Category
- Scans Event Category
- Security Audit Event Category
- Sessions Event Category
- Stored Procedures Event Category
- Transactions Event Category
- TSQL Event Category
- User Configurable Event Category
- Creating and Managing Traces and Templates
- SQL Profiler Performance Considerations
-
Monitoring with System Monitor
- Monitoring Disk Activity
- Monitoring CPU Usage
- Monitoring Memory Usage
- Creating a SQL Server Database Alert
- System Monitor Scenarios
- Running System Monitor
- Creating Charts, Alerts, Logs, and Reports
-
Using SQL Server Objects
- SQL Server: Access Methods Object
- SQL Server: Backup Device Object
- SQL Server: Buffer Manager Object
- SQL Server: Buffer Partition Object
- SQL Server: Cache Manager Object
- SQL Server: Databases Object
- SQL Server: General Statistics Object
- SQL Server: Latches Object
- SQL Server: Locks Object
- SQL Server: Memory Manager Object
- SQL Server: Replication Agents Object
- SQL Server: Replication Distribution Object
- SQL Server: Replication Logreader Object
- SQL Server: Replication Merge Object
- SQL Server: Replication Snapshot Object
- SQL Server: SQL Statistics Object
- SQL Server: User Settable Object
- Monitoring with SQL Server Enterprise Manager
- Monitoring the Error Logs
- Monitoring with Transact-SQL Statements
- Monitoring with SNMP
- Using the Web Assistant Wizard