TROUBLESHOOTING - Database in Suspect Mode

Post Reply
Andre
Posts: 15
Joined: Mon Dec 30, 2013 8:00 am

TROUBLESHOOTING - Database in Suspect Mode

Post by Andre » Tue Nov 27, 2018 8:06 am

  • Analyze the exact error, when certain that it indeed is on suspect mode.
  • Try rebooting the server.
  • If this doesn't resolve the problem, check if you can open any SQL services.
  • If SQL opens, run a DBCC check on the database in 3 phases, when this is done restart the server.
  • If SQL doesn't open, check for the latest back up and inform the client of the possible data loss.
  • Do a SQL re-install.

Post Reply