August 25, 2021 at 4:58 am
What is suspect mode?
Is the database suspect mode solved automatically?
If no, Any other methods available to resolve the suspect mode of a database in SQL?
As mentioned in the link,
https://www.mytechmantra.com/sql-server/how-to-repair-database-in-suspect-mode-in-sql-server/
The EMERGENCY repair mode to recover suspect mode in database is already checked.
August 25, 2021 at 7:12 am
Suspect mode is something is wrong with the database, missing files, corruption of header pages, could be a wide variety of issues that cause suspect mode.
Suspect mode is not resolved automatically.
You need to look at the SQL error log and see why the engine thought the database is suspect and resolve that issue, depending on what caused suspect will depend on what action needs to be undertaken.
Could be permission problems, could be corruption, could be missing files, could be anything, you need to check and find the right root cause and fix that.
Make sure you have a good backup chain and ensure they are intact otherwise it can get painful very quickly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply