Online Documentation for SQL Administrator for SQL Server

Database options


The Database options section of the Server Properties dialog allows you to configure the instance of Microsoft® SQL Server by setting options pertaining to database.

 

Server properties - Database options

 

 

Default index fill factor in %

This value specifies how full SQL Server should make each page when it creates a new index using existing data. The fill factor affects performance because SQL Server takes time to split pages when they fill up.

The default value is 0; valid values range from 0 to 100. A fill factor of 0 or 100 creates clustered indexes with full data pages and nonclustered indexes with full leaf pages, but it leaves some space within the upper level of the index tree. Fill factor values 0 and 100 are identical in all respects.

With low fill factor values specified, SQL Server creates indexes with pages that are not full. Each index takes more storage space, but there is more room for subsequent insertions without requiring page splits.

 

Recovery interval in minutes

Sets the maximum period of time to recover a database. The default is 0, it stands for automatic configuration by SQL Server. In practice, this means a recovery time of less than one minute and a checkpoint approximately every one minute for active databases.

 

Default data files location

Specify the default location for data files: type in the path in the Data field or use the OpenFile button to browse for directory using the SQL Server Folders dialog.

 

Default log files location

Specify the default location for log files: type in the path in the Log field or use the OpenFile button to browse for directory using the SQL Server Folders dialog.

 

 

Backup and restore options

 

Waiting for a new tape

!RadioButton Wait indefinitely

Specifies that SQL Server will never time out while waiting for a new backup tape.

 

!RadioButton Try once

Specifies that SQL Server will time out if a backup tape is not available when needed.

 

!RadioButton Try for ... minute(s)

Specifies that SQL Server will time out if a backup tape is not available within the defined period of time.

 

Default backup media retension in days

Provides a system-wide default for the length of time to retain each backup medium after it has been used for a database or transaction log backup. This option helps protect backups from being overwritten until the specified number of days has elapsed.

 

!CheckBox Compress backups by default

Check this option to enable default compression of backups.