SQL Server database has been marked "suspect"

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server database has been marked "suspect"

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2007-05-05 : 04:52:06

Hi
i got that my Two dataBase marked "suspect".How i solve this problem.
I change status of suspect database by Below given Query but not solved.Help me urgent..
USE Master
GO

-- Determine the original database status
SELECT [Name], DBID, Status
FROM master.dbo.sysdatabases
GO

-- Enable system changes
sp_configure 'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO

-- Update the database status
UPDATE master.dbo.sysdatabases
SET Status = 24
WHERE [Name] = 'YourDatabaseName'
GO

-- Disable system changes
sp_configure 'allow updates',0
GO
RECONFIGURE WITH OVERRIDE
GO

-- Determine the final database status
SELECT [Name], DBID, Status
FROM master.dbo.sysdatabases
GO

Ranjeet Kumar Singh

hvdtol
Yak Posting Veteran

50 Posts

Posted - 2007-05-05 : 06:00:58

Did you already restart the Sql server service?
As far as i know you need to do this, to get it out of the suspect state, after changing the configuration settings..

hvdtol

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-05 : 12:47:46

Check windows event log to see if have disk related error.

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-05-06 : 17:04:34

I don't think it is good idea to change the status before checking sql error log and application logs...
First deteremined what caused these databases go into suspect mode and take the action based on the reason...
Just changing the status will not always correct suspected dbs....

MohammedU

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources