Configuring Databases


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 Enterprise Manager. 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.

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.

Recovery models are a new feature of SQL Server 2000. Different recovery models replace various combinations of the SQL 7.0 settings trunc. log on chkpt and select into/bulk copy. For example, the Recovery Model Full corresponds to a SQL Server 7.0 setting where both the options trunc. log on chkpt and select into/bulk copy  are disabled.

To change the Recovery Model to Full you can use the Enterprise Manager as described below or enter the command:

alter database <SAPSID> set recovery full



       1.      In the Enterprise Manager expand your server and Databases.

       2.      Select a database. Normally this will be the <SAPSID>database. Choose Action ® Properties.

The 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.