Redindexing Database Problem

When I try to Reindex the database I get the following error: "Error reindexing database -2147467259 An inconsistency was detected during an internal operation in database '****'(ID:6) on page (1:160999). Please contact technical support. reference number 7."

Can anybody tell me exactly what this means and how I can fix this. Has anybody else ran into this problem?

Any (quick) help or info would be appreciated.

Reply to
Alex
Loading thread data ...

If this is a store database connected to HQ, then you will need to export a new copy of the database from HQ. If this is an HQ database, you will need to restore from latest good backup and then resync stores from that time. If this is a standalone store, then restore from latest good backup and redo transaction activity from that time. If there is no backup to restore from, then you are in trouble. None of these options are pretty, and require some bit of work, and chance of lost data. Hopefully someone else will reply with a better solution.

Reply to
Matt Hurst

When I try to Reindex the database I get the following error: "Error reindexing database -2147467259 An inconsistency was detected during an internal operation in database '****'(ID:6) on page (1:160999). Please contact technical support. reference number 7."

Can anybody tell me exactly what this means and how I can fix this. Has anybody else ran into this problem?

Any (quick) help or info would be appreciated.

Reply to
cptsoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.