How to set the recovery interval (Enterprise Manager)

To set the recovery interval

  1. Expand a server group.
  2. Right-click a server; then click Properties.
  3. Click the Database Settings tab.
  4. In the Recovery interval (min) box, select a value from 0 through 32,767 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.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.