Overview

The Patterns & Practices team has decided to archive this content to streamline content offerings and keep focused on the newest, most relevant content. However, we will continue to make this content available because it is still of interest to some users. We offer this content as-is, without warranty that it is still technically accurate as some of the material may be outdated. Note that the content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.

To manage SQL Server in a day-to-day environment, an operations team needs to perform a wide variety of procedures, including server monitoring, backup, verification of scheduled events, capacity planning, and developer and end user support. This guide includes instructions for the procedures along with steps for dealing with unresolved issues in a timely manner.

The content of the Operations Guide draws from the knowledge and best practice guidelines from Microsoft Consulting Services (MCS), Microsoft's Internal Technical Support Group, and the SQL Server Development Team.

• Chapter 1: Introduction

• Chapter 2: Change, Configuration, and Release Management

• Chapter 3: Security Administration

• Chapter 4: System Administration

• Chapter 5: Monitoring and Control

• Chapter 6: Capacity and Storage Management

• Chapter 7: Problem and Incident Management

• Chapter 8: Service Management

• Download all chapters from the Microsoft Download Center

Who We Are

The team that produced the SQL Server 2000 Operations Guide came from a wide range of areas within Microsoft and from many of our partner organizations. The following people make a substantial contribution to the writing, developing, and testing of this content.

Content Lead

Andrew Mason – Microsoft Prescriptive Architecture Group

Key Authors

Saskia Schott – SQLSoft+
Jerry Spivey - SQLSoft+
Jim Skinner – Microsoft Consulting Services
Cathan Cook – Microsoft Consulting Services
Allan Hirt – Microsoft Consulting Services

Reviewers

Richard Waymire - Microsoft SQL Server Product Group
Joe Yong - Microsoft SQL Server Product Group
Tom Lucas - Microsoft ITG
Rebecca Laszlo - Microsoft SQL Server Product Group
Girish Chander - Microsoft SQL Server Product Group
Patrick Conlan - Microsoft SQL Server Product Group