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; 

 See also Microsoft Learn