Database recovery
Use the Options page of the Restore Database dialog box to modify the behavior and outcome of the restore operation. To use SQL Server Management Studio to restore a database backup => https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-database-options-page?view=sql-server-ver15
To determine the state of the database after the store operation, you must select one of the options of the Recovery state panel.
1. RESTORE WITH RECOVERY
Recovers the database after restoring the final backup checked in the Backup sets to restoregrid on the General page. This is the default option and is equivalent to specifying WITH RECOVERY in a RESTORE statement ( Transact-SQL).
Note
Under the full recovery model or bulk-logged recovery model, choose this option only if you are restoring all the log files now.
2. RESTORE WITH NORECOVERY
Leaves the database in the restoring state. This allows you to restore additional backups in the current recovery path. To recover the database, you will have to perform a restore operation by using the RESTORE WITH RECOVERY option (see the preceding option).
This option is equivalent to specifying WITH NORECOVERY in a RESTORE statement.
If you select this option, the Preserve replication settings option is unavailable.
3. RESTORE WITH STANDBY
Leaves the database in a standby state, in which the database is available for limited read-only access. This option is equivalent to specifying WITH STANDBY in a RESTORE statement.
Choosing this option requires that you specify a standby file in the Standby file text box. The standby file allows the recovery effects to be undone. Standby file Specifies a standby file. You can browse for the standby file or enter its pathname directly in the text box.
View or Change the Recovery Model of a Database (SQL Server)
A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. Three recovery models exist: simple, full, and bulk-logged. Typically, a database uses the full recovery model or simple recovery model. A database can be switched to another recovery model at any time. The model database sets the default recovery model of new databases (https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/view-or-change-the-recovery-model-of-a-database-sql-server?view=sql-server-ver15).
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver15
Example:
Answer:
Other resources: