Configuring Databases 

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

Procedure

  1. In the Enterprise Manager expand your server and Databases.
  2. Select a database. Normally this will be the <SAPSID> database. Choose Action ® Properties.

    3. The Edit Properties dialog box opens for the selected database.

  3. Switch to the Options tab.
  4. Select and deselect the options as required. For information on the individual options choose Help. Keep the following recommendations in mind:

Truncate log on checkpoint

This deletes the inactive part of the transaction log whenever a checkpoint occurs. In a production system, set this option for the master and msdb databases. No logs are required for these.

Select into/bulk copy

Set this for the tempdb. It allows special operations to be performed that are not logged.

Never set Truncate log on checkpoint or Select Into/Bulk copy for the R/3 database in a productive system. When Truncate log on checkpoint is set, the inactive part of the transaction logs is deleted whenever a checkpoint is processed. This means logs are deleted before they can be backed up and will therefore not be available when a damaged database has to be restored.

Select Into/Bulk switches off logging for special operations. It is used to prevent the logs from filling up when large amounts of data are transferred.

If one of the parameters has been set, you need to deselect it and backup the complete database immediately.