database_state

--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:

When recovering a system database, this parameter is ignored. System databases are always recovered in the recovery state.