Discussion Board

quizz test Hoi 07-14-2021 09:12 PM

Database states A database is always in one specific state. For example, these states include ONLINE, OFFLINE, or SUSPECT. To verify the current state of a database, select the state_desc column in the sys.databases catalog view or the Status property in the DATABASEPROPERTYEX function. Following are the database states: 1. ONLINE: This database is available for access. The primary filegroup is online, although the undo phase of recovery may not have been completed. 2. OFFLINE: This database is unavailable. A database becomes offline by explicit user action and remains offline until additional user action is taken. 3. RESTORING: One or more files of the primary filegroup are being restored, or one or more secondary files are being restored offline. The database is unavailable. 4. RECOVERING: This database is being recovered. The recovering process is a transient state; the database will automatically become online if the recovery succeeds. If the recovery fails, the database will become suspect. The database is unavailable. 5. RECOVERY PENDING: SQL Server has encountered a resource-related error during recovery. The database is not damaged, but files may be missing or system resource limitations may be preventing it from starting. The database is unavailable. 6. SUSPECT: At least the primary filegroup is suspect and may be damaged. The database cannot be recovered during startup of SQL Server. The database is unavailable. Additional action by the user is required to resolve the problem. 7. EMERGENCY: User has changed the database and set the status to EMERGENCY. The database is in single-user mode and may be repaired or restored. EMERGENCY is primarily used for troubleshooting purposes. Prajakta Pandit 03-10-2017 04:35 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*