Purpose

The purpose of this article is to teach you the process of starting, pausing and stopping SQL Server 2000. When you start an instance of SQL Server, you are starting the SQL Server service. After you start the SQL Server service, users can establish new connections to the server. The SQL Server service can be started and stopped as a Microsoft Windows 2000/2003 or Windows NT 4.0 service, either locally or remotely.

To start an instance of Microsoft SQL Server 2000

To start the instance of Microsoft SQL Server 2000 follow the steps as below:

1. Click on Start, go to Programs and then go to Microsoft SQL Server and click on Service Manager.

2. Click Start.

To pause the instance of Microsoft SQL Server 2000

Following step describes you the process of pausing the instance of Microsoft SQL Server 2000:

1. Click Pause.

To stop the instance of Microsoft SQL Server 2000

Follow the step as below to stop the instance of Microsoft SQL Server 2000:

1. Click Stop.