How to set the recovery interval (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set the recovery interval (Enterprise Manager)

To set the recovery interval

  1. Expand a server group.

  2. Right-click a server, and then click Properties.

  3. Click the Database Settings tab.

  4. Under Recovery, in the Recovery interval (min) box, type or select a value from 0 through 32767 to set the maximum amount of time, in minutes, that Microsoft® SQL Server™ should spend recovering each database at startup.

    The default value is 0 minutes, indicating automatic configuration.