Change the target recovery time

This article describes how to set or change the target recovery time of a database in SQL Server by using SQL Server Management Studio or Transact-SQL. By default, the target recovery time is 0 or 60 seconds, and the database uses indirect checkpoints. The target recovery time establishes an upper bound on recovery time for this database.

This setting takes effect immediately and doesn't require a restart of SQL Server.

ALTER DATABASE MXSuite
SET TARGET_RECOVERY_TIME = 60 SECONDS;