recovery interval option to set the maximum number of minutes per database that SQL Server requires to recover databases. recovery interval set to 0 (self-configuring) unless you notice that the checkpoints hinder performance because of frequent occurrence. increase value in small increments
|