![CHAINED option [TSQL]](arrow-left.gif){kind=icon}
Set the maximum length of time, in minutes, that the database server will run without doing a checkpoint.
Integer
Can be set only for the PUBLIC group. DBA authority is required to set the option. You must shut down and restart the database server for the change to take effect.
60
This option is used with the “RECOVERY_TIME option” to decide when checkpoints should be done.
