Starting and Stopping the SQL Server 

Prerequisites

When you start up SQL server you actually start the Windows NT Service MSSQLServer and the corresponding process sqlservr.exe.

In addition to starting the server, you also need to start SQL Server Agent in order to be able to schedule and execute jobs within the Enterprise Manager. Other services offered by the SQL server are not required in the R/3 environment and should therefore not be started.

Overview of SQL Server Services

Service

Process

Comment

MSSQLServer

sqlservr.exe

Always required

SQLServerAgent

sqlagent.exe

Always required

MSDTC

msdtc.exe

Do not run in the R/3 environment

Microsoft Search

mssearch.exe

Do not run in the R/3 environment

You can view a list of all installed services and their current status in the NT Service Manager. Choose Control Panel ® Settings ® Control Panel ® Services.

You can start the SQL Server using the SQL Server Service Manager or the Enterprise Manager.

Procedure

  1. In the NT task bar, double-click on the server icon located on the right beside the time display.

    2. The SQL Server Service Manager dialog box appears.

  2. Select the server you want to start or stop.
  3. Select the service MSSQLServer.
  4. Choose either start or stop as required.

The server is started up or shutdown immediately.
During startup, an automatic recovery takes place.
During shutdown a checkpoint is performed in every database.

Never Pause a server. This option prevents any further connections being established to the server and may cause R/3 errors.

Repeat the procedure for the service SQLServerAgent. The SQL Server Agent must be started to allow the scheduling of tasks in the Enterprise Manager.

Optionally, SQL Server and SQL Server Agent can be started automatically whenever Windows NT starts. If you wish to implement this option, use the NT Service Manager to specify that the services should be started together with Windows NT. For more information see the Windows NT documentation.