Check Database Error (HELP!!!!)

Aug 02, 2007 2 Replies

I am trying to process a stocktake, I get to the calculate screen, press commit and it keeps coming up with timeout error (after only 5-6 mins) and quitting out of Store operations manager, so I tried reindexing it, and that completed fine and backed up database which also completed fine so then I then did Store operations admin check database facility and I got the following error Error -2147212540: Table error: Object ID 453576654, index ID 1, partition ID 72057594041925632, alloc unit ID 71805844660813824 (type LOB data). The off-row data node at page (1:2840), slot 18, text ID 235971674112 is not referenced.



I

Run the statement

DBCC CHECKDB 'YourDatabase' WITH ALL_ERRORMSGS

cod

ops .. this statement is only for check.. before run check, try to make a database backup, and set database in single user mode (no users must be connected to database).. You can loss data from database, or this can be an I/O error from disk ...

cod

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required