December 2, 2002 at 6:27 am
Hi! i have a DB marked as 'Suspest'. BOL tells me that is a result of a process of lack of disk space, but this is not my case.
Must i run the sp_resetstatus or do you reccomend anything else?
December 2, 2002 at 6:59 am
Try sp_resetstatus first to remove the suspect marker and see what happens. Once set that is the only right way to remove. Then let us know if still an issue.
December 2, 2002 at 7:28 am
The sp_resetstatus works Ok, thanks for your support!
December 5, 2002 at 8:02 pm
I would verify your data base. Resetting the "suspect" status bit did only that: turned off the error. Use DBCC to verify your data base is still fully intact. And I'd review my backup/recovery plan soon (ie. today)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply