Suspect Database-Any Solution 1

[ISChana]

Dear All Guru's of SQL

Yesterday when I tried to take the backup of my SQL Database I saw suspect written in its name and there was no item in the database I tried to copy mydatabase.mdf file on another server but it was not recovered i also checked event log error there was long messgae like forwardasy....wriiten I coun't understand.

Can anybody help me in this regards, how to recover the data and why this happend

regards

Inderjeet

 

[Wholsea]

Lots of hits on groups.google.com for this issue.

Quick link to one:

http://groups.google.com/group/comp...r+database+is+suspect&rnum=1#96637c2d2cd3d280

ITs fairly common, and can be sourced at a number of different things...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[NoCoolHandle]

You probably need to read the above link, but if you just want to remove the suspect status and bring it back on line (accepting any inconsistancy that might exist inside it) and you can't recover from your backups..

I have a nice little helper for you on my website..

http://lynchtek.com/sql.aspx

go to the link on fixing a suspect database.

 

[NoCoolHandle]

Sorry wrong link...

try

http://lynchtek.com/suspectdb.htm

Rob

 

[SQLBill]

I find that if my database is shown as SUSPECT, all I need to do is Detach it and then Attach it.

For me, it seems to happen if SQL Server was shutdown with users still connected to the database.

-SQLBill

Posting advice: FAQ481-4875

 

[NoCoolHandle]

I need to add that nice little snit bit to my website..

ta bill