The following list includes mount recovery types:
- RECOVERY: Instructs the recovery operation to roll back any uncommitted transactions. After the recovery process, the database is ready for use.
- NORECOVERY: Instructs the recovery operation not to roll back any uncommitted transactions. When in NORECOVERY mode, the database is unusable. This option is useful when the Database Administrator must restore one or more transaction log backups. The database is attached to the instance selected for recovery and is left in the RESTORING state.
- STANDBY: Recovers files and opens the database in a read-only mode. Next, the Database Administrator can manually apply additional transaction log backups.
Note: RECOVERY, NO RECOVERY, and STANDBY modes are not supported for Non-VDI and crash-consistent copies.
If recovering a database from an older version of SQL server onto a newer version of SQL, do not use standby mode. By using standby mode, the upgrade to the newer version cannot be supported and thus results in a failure of the operation.
- ATTACH DATABASE: Mounts the file system on which the database files are located and attaches the database to the SQL Server. The Attach Database Recovery Type option is only available for Non-VDI and Crash Consistent copies. More steps for full recovery of the database may be required.
Note: Attach Database is NOT SUPPORTED for Full or Copy SQL copies.