--database_state={recovery|norecovery|standby}
The state of the recovered database. The parameter is used with the recover mssql_database command.
Available values of the parameter are as follows:
After the recovery completes, the database will be ready for use. Users will have full access to it. The software will roll back all uncommitted transactions of the recovered database that are stored in the transaction logs. You will not be able to recover additional transaction logs from the native Microsoft SQL backups.
After the recovery completes, the database will be non-operational. Users will have no access to it. The software will keep all uncommitted transactions of the recovered database. You will be able to recover additional transaction logs from the native Microsoft SQL backups and thus reach the necessary recovery point.
After the recovery completes, users will have read-only access to the database. The software will undo any uncommitted transactions. However, it will save the undo actions in a temporary standby file so that the recovery effects can be reverted.
The standby value is primarily used to detect the point in time when a SQL Server error occurred.
When recovering a system database, this parameter is ignored. System databases are always recovered in the recovery state.