Starting and Stopping the SQL Server (SAP Library - Database Administration in CCMS)

Starting and Stopping the SQL Server

Prerequisites

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

In addition to starting the server, you also need to start the SQL Server Agent 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
SQL Server	sqlservr.exe	Always required
SQL ServerAgent	sqlagent.exe	Always required
Distributed Transaction Coordinator	msdtc.exe	Do not run in the SAP environment
FDHOST Launcher	fdhost.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 Services application.

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

Procedure

...

1. Start the Server Configuration Manager.

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 Services application to specify that the services should be started together with Windows. For more information, see the Windows documentation.