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.