Purpose

The purpose of this article is to teach you the process of setting up the recovery interval in Microsoft SQL Server 2000.

To Set the Recovery Interval

Recovery interval option is used to set the maximum number of minutes per database that Microsoft SQL Server needs to recover databases. Each time an instance of SQL Server starts, it recovers each database, rolling back transactions that did not commit and rolling forward transactions that did commit but whose changes were not yet written to disk when an instance of SQL Server stopped. This configuration option sets an upper limit on the time it should take to recover each database. The default is 0, indicating 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.

Following steps describe the step by step details of setting up the recovery interval:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, then click Properties, and select Database Settings tab.

3. Now, set a value for Recovery interval (min) in minutes.

4. Click OK.