![]() ![]() ![]() In that case, you can try restoring the database from an updated backup. However, if the database gets stuck in restoring/recovery modes or goes in SUSPECT mode, the database cannot be accessed at all. The database in RESTORING and RECOVERING states becomes available once the database is restored and recovered. And so, repair operations can be run on a damaged SQL database when it is in ONLINE state. The database in ONLINE state can be accessed by users. Only a user having sysadmin privileges can change the database status to EMERGENCY. The database will be in single-user mode and can be repaired or restored.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |