i have a terrible problem with my MS SQL Database. All of the sudden, while working in the application that is using the database it has stopped working and closed (with no error message). Restarting the application, it could not connect back to the database... restart, reboot, reload MS SQL service and still nothing. That was the time i loaded MS SQL Management Studio Express 2005 (v9.00). There i've noticed that my database was marked with Suspect status. I did a lot of research on the net and on this portal trying to find a solution... none of the steps explained in different posts were good for me. Can anyone describe a step by step tutorial to try repairing my database?
My server is:Microsoft SQL Server 2000 - 8.00.760 (Intel X86), Dec 17 2002 14:22:05, Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 3) and has been running for three years with no flaws. Also i don't have a recent backup only made a copy of the mdf and ldf files after the crash.
I'm not interested into buing 400$ or more worth of software just to repair a database (i've already paid for the SQL license... ) as i saw some providers offer.