SQL Server Properties (Database Settings Tab)
Use the Database Settings tab to view or specify the following options.
Options
Fixed
Set the default index fill factor manually. The index fill factor determines how full Microsoft® SQL Server™ makes each page when it creates a new index using existing data. When this option is cleared, SQL Server selects the optimal setting for performance.
Wait indefinitely
Specify that DB-Library must wait indefinitely for the instance of SQL Server to respond.
Try once then quit
Specify that DB-Library must try once to connect to an instance of SQL Server and then time out.
Try for minute(s)
Specify the time, in minutes, that DB-Library must try to connect to an instance of SQL Server before timing out.
Default backup media retention (days)
Set a system-wide default for the length of time to retain each backup medium after the backup has been used for a database or transaction log backup.
Recovery interval (Min)
Set the maximum number of minutes per database that SQL Server needs in order to complete its recovery procedures. The default is 0 minutes per database, which is the autoconfiguration for fast recovery.
Default data directory
Specify the default directory used for data files when new databases are created in SQL Server. Click the browse (...) button to search for an existing data directory.
Default log directory
Specify the default directory used for log files when new databases are created in SQL Server. Click the browse (...) button to search for an existing log directory.
Configured values
View or change the configured values for the options on this tab. If you change these values, click Running values to see whether the changes have taken effect. If they have not, you must restart the instance of SQL Server for the changes to be implemented.
Running values
View the current running values for the options on this tab. These values are read-only.
See Also
How to set a fixed fill factor (Enterprise Manager)
How to set the backup retention duration (Enterprise Manager)