recovery interval
Type: Advanced, self-configuring
Default value: 0
The recovery interval
parameter is used to specify the maximum time (in minutes) that SQL Server requires to recover a database during startup. During startup, SQL Server rolls forward all the changes committed during a SQL Server crash and rolls back the changes that were not committed. Based on the value specified for this parameter, SQL Server determines when to issue a checkpoint in every database of SQL Server so that in the event of a crash, SQL Server can recover the databases in the time specified by recovery interval
. If the value of the recovery interval
parameter is low, SQL Server issues checkpoints more frequently to allow a recovery to be faster; however, frequent ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.