# 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.

```sql
ALTER DATABASE MXSuite
SET TARGET_RECOVERY_TIME = 60 SECONDS;
```

See also [Microsoft Learn](https://learn.microsoft.com/en-us/sql/relational-databases/logs/change-the-target-recovery-time-of-a-database-sql-server?view=sql-server-ver17)