I posted previously "Corrupted index - find out what caused it".
I've had the file system checked, check disk etc no issues. Rebooted server
It is running on SQL 2005. Workgroup edition.
It effects a single indexed view in one DB. The view has a clustered index and a unique non clustered index.
It would SEEM the maintenance job to rebuild indices is causing corruption. This job
1. re builds all indices in selected dbs
2. runs checkdb on these DBs
I put step 2 in to confirm the corruption was caused by index rebuild.
A valid checkdb ran 30 mins before reindex. There was no activity on server in this 30mins.
I will now put an extra checkdb before the reindex so I know exactly when it happens so I check before and after rebuild.
The problem has come about since I introduced an indexed view. As it's workgroup edition I have to use (NOEXPAND) in queries to get the queries to use the view indices.
Thanks for reading my post