Show TOC

Configuring DatabasesLocate this document in the navigation structure

Use

Database options allow you to configure each database individually. If you set options for a particular database this does not affect any of the other databases. The most commonly used configuration options can be set in the SQL Server Management Studio. Other, more advanced options can be set with the stored procedure sp_dboption as described in the SQL Server Books Online.

When you set a database option, it immediately takes effect.

Caution

For the SAP database, you must set the Recovery model for the database to Full.

By setting this type of model you guarantee that all operations are fully logged. This ensures that if one or more data files are damaged, you can restore all committed transactions.

To change the Recovery Model to Full, use the SQL Server Management Studio as described below, or enter the command:

alter database <SAPSID> set recovery full

Procedure

  1. In the SQL Server Management Studio expand your server and Databases.
  2. Right-click the<SAPSID> database and choose Properties.

    The Database Properties dialog box opens for the selected database.

  3. Switch to the Options tab. Select and deselect the options as required. For information on the individual options choose Help.