Hi,
no it wasnt the first time. but i´ve noticed that the database was running in compatibilty mode (sql 8 2000) and then i have changed it to native (sql 2005) mode. I changed it back several times and then running dbcc checkdb, but it didn´t work my way.
What table/index should I rebuild/drop/re-create?
I think I now what happened. The database is part of a German CRM system which uses own replication algorythm. on friday there were some suspicious error messages i think which will have caused the desaster now. The main system and main database has the errors, the replication partner which uses a full replication (fyi: no MS SQL replication!) has no errors running dbcc checkdb.
What is very strange is that I used backup files and restored the database from over the last two weeks and now they fail, too - thats what I don´t understand.
Perhaps you can tell me what my possibilities to recreate or rebuild the indexes.
Thank you.
Holger Degroot