How can i repair suspected sql server 2000 database

Question

My Sql database is suspected. Its very important for me. I want to repair my suspected database. I've read different articles but could not understand how to repair.

Answer 1

You just need to follow simple steps..

Create a new database, open your suspected database in emergency mode and then you can export tables one by one from suspected database to newly created database.

Here question comes, how can we open database in emergency mode. In SQL Server maintains list user created databases and their status and other information is stored in master database. So we just need to change the status of suspected database from master table. How can we do that..??

As you are working with sql server 2000, open Query Analyzer and write follow query

USE master
sp_configure 'allow updates', 1
GO
Reconfigure with override
GO
Update sysdatabases set status=32768 where name='YOUR DB NAME'
GO
sp_configure 'allow updates', 0
GO
Reconfigure with override

Now restart your configuration manager, here you can perform the above operations.. (export to another database)

Source of this query : http://sharp-coders.blogspot.com/2012/10/repair-sql-server-suspected-database.html