hi everyone - i have spotted the following errors when running dbcc checkdb on some databases: msg: 8966, 8921, 8909, 2533, 926, 5269, 824, 823. i suspect all databases are corrupt. i think the best way to resolve this is to restore from a previous backup, however, if i use a backup before the corruption we will lose too much data. 1) can i do a partial restore to avoid losing too much data? if so how can this be done? 2) if a partial restore is possible then should i restore a second database and manually import data from the newer corrupted database, or can i import uncorrupted data from a backup? 3) Is there a list of all these database integrity errors in a handy reference document? 4) If I don't restore the databases and leave the integrity errors, what will the result be? will the database still remain operational???????
Some of the errors are related to corruption in system tables http://www.sqlservercentral.com/articles/Corruption/65804/ Hope this helps.