Starting and Stopping the SQL Server (SAP Library - SAP/ MS SQL Server DBA in CCMS)

Starting and Stopping the SQL Server

Prerequisites

When you start the SQL Server you actually start the Windows service MSSQLServer and the corresponding process sqlservr.exe.

In addition to starting the server, you also need to start the SQL Server Agent in order to be able to schedule and execute jobs within the SQL Server Management Studio. Other services offered by the SQL Server are not required in the SAP 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 SAP environment
Microsoft Search	mssearch.exe	Do not run in the SAP environment

Note

You can view a list of all installed services and their current status in the Windows Service Manager. Choose Start ® Control Panel ® Administrative Tools ® Services.

You can start the SQL Server using the SQL Server Service Manager or the SQL Server Management Studio.

Procedure

...

1. Choose Start ® All Programs ® Microsoft SQL Server ® Configuration Tools ® SQL Server Configuration Manager.

The SQL Server Configuration Manager dialog box appears.

2. Select SQL Server Services.

3. Select the service SQL Server (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.

Caution

Never use Pause for a server. This option prevents any further connections being established to the server and may cause SAP errors.

5. Repeat the procedure for the service SQL Server Agent (MSSQLServer).

The SQL Server Agent must be started to allow the scheduling of tasks in the SQL Server Management Studio.

Note

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