Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cgunner
Yak Posting Veteran
95 Posts |
 Posted - 2005-08-12 : 15:08:51
|
I am getting the following after kicking off DBCC CHECKDB 'DATABASE', REPAIR_ALLOW_DATA_LOSS) :Executed as user: USER. Database 'TEST' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing. [SQLSTATE 42000] (Error 7995) Clustered index successfully restored for object 'syscolumns' in database 'TEST'. [SQLSTATE 01000] (Error 2592) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528). The step failed.I have found this link:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_4d2r.aspNot good. Has anyone experianced this before.  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-12 : 15:11:03
|
| Post your question in the Data Corruption forum here as MS employees watch that forum for corruption issues.Tara |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-12 : 15:11:36
|
| Which build are you on?Do you always run with REPAIR_ALLOW_DATA_LOSS by default?Can you run the following in QA:DBCC CHECKDB ('DATABASE') WITH NO_INFOMSGSI need to see the error state numbers to tell you what's wrong.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2005-08-12 : 15:31:09
|
| I will re-post. paulrandal this command was ran after DBCC CHECKDB ('DATABASE') WITH NO_INFOMSGS. We found corruption and ran REPAIR_ALLOW_DATA_LOSS. |
|
|
|
|
|
|
DBCC CHECKDB failing