HiGail,

Can you please explain "By setting the recovery interval to 90 sec, you're saying to SQL run the checkpoint process often enough that should the SQL service restart unexpectedly, the duration of the restart recovery will not exceed 90 seconds."

Does it mean that SQL Server will automatically apply Checkpoint command to the database after 90 seconds?

Thanks in advance!!!