Forum Discussion

Chengcheng210's avatar
Chengcheng210
Copper Contributor
Jun 21, 2020

database in suspect mode

Hi, there,   I'm experiencing a tough issue for me. When I was updating the some columns into the database I have previously install, the main memory corruption led the database jump into the suspe...
Mkelsawy's avatar
Mkelsawy
Copper Contributor
Oct 18, 2020

Hi Chengcheng210 ,

The most important thing is never detach a suspect database. You can try to recover some data from a suspect database by using the emergency mode. But the only advisable solution would be to perform a database restore.

 

also try first to restart SQL Server Engine service and check after database comes up again .

 

last you need to check this tool (Stellar Repair) it used before by one of my colleagues and it's works (link removed by moderator)

  • Robin Shanab's avatar
    Robin Shanab
    Iron Contributor
    Sep 24, 2021
    Hi,
    This tool worked for me. Thank you so much for sharing.

Resources