Forum Discussion
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...
Do you have admin rights? It seems like u don't have the rights. (as per the error message that you are getting after running step 2)
I will suggest you restore the database from the updated backup copy. If the backup is not updated, make a copy of the MDF file and repair it using the DBCC CHECKDB repair option.
Any SQL repair tool would be the last and emergency resort to fix the corruption. I read an amazing review of SQL Repair Software by SQL MVP Grant Fritchy, a product advocate in RedGate Software. Check here: (link removed by moderator)