HELP-Is my dB corrupt?

[christine1]

Okay, this is not happening. I recieved the following error message:
Msg 625, Level 20, State 1
Couuld not retrieve row from logical page 3855464 via RID
because the entry in the offset table (=0) for that RID (=9)
is less than 0.
The SQL Server is terminting this process.


If in fact tmy dB is corrupt what is the best method to restore it back to its original health. Keep in mind I cannot be sure when the corruption took place so I cannot be sure how many back-ups to go back to. To add insult to injury I ran DBCC Checkdb and it gave me nothing.

Any assistance would be greatly appreciated.

Christine [sig][/sig]

 

[foxdev]

Try this:

dbcc checkdb repair_rebuild [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[christine1]

I keep getting syntax errors. I'm sure I am leaving off something. Here's what I've got:

dbcc dbrepair DBNAME
error

dbcc dbrepair_rebuild DBNAME
error

Do I need to add a dropdb? Please help as this db is mission critical to the company and I am holding up process.

P.S. The database is 6.5. [sig][/sig]

 

[foxdev]

P.S. The database is 6.5.

Sorry...my advice was for 7.0. I can't help you with 6.5. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]