July 30, 2007 at 5:41 am
Dear all,
this morning suddenly i got suspect problem with my database. Suddenly, my database: ReportASM turned into suspect mode. So, i try to restart the services. After that, Enterprise Manager not even recognize ReportASM.
I try to attach it, but it was failed. Even with tsql:
GO
CREATE DATABASE Archive
ON PRIMARY (FILENAME = 'd:\datasql\MSSQL\Data\ReportASM1_Data.mdf')
FOR ATTACH
GO
this query returns this error:
Server: Msg 3624, Level 20, State 1, Line 1
Location: xdes.cpp:9884
Expression: (m_state == XDES_ACTIVE_NOLOG) || (m_state == XDES_INVALID)
SPID: 55
Process ID: 1960
Connection Broken
I've never execute exec sp_resetstatus and i still have approx. 90gb free space. And the day before (on saturday and sunday), my db error log shows so much error. and i also already try dbcc dbrecover(reportasm).
Any suggestion or solutions for this problem? I will very appreciate it. thanx.
July 30, 2007 at 2:53 pm
There are two main reasons for a database marked as suspect. Disk runs out of space and data corruption. Here are two links. Hopefully, they are helpful.
http://www.devx.com/vb2themax/Tip/18624
http://www.windowsitpro.com/Article/ArticleID/14047/14047.html
August 24, 2007 at 2:49 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply