Hi,

Just a quick update on this situation for anyone who may be interested..

I was able to resolve this issue by restoring a previous backup of the DB in question (using the with replace option).

Although this lead to data loss it was acceptable because we have a process which synchronises data into this DB from another data source, so we were able to load the missing data.

After restoring the DB, DBCC Check DB completed successfully without returning any error messages.

Could this be because the restore effectively moved the MDF to a different part of the disk? This is still cause for concern in the long run but at least the DB is back online again now with no errors.

Thanks,

Phil