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:32:13
|
| 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. |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-12 : 16:02:27
|
| Which build are you on?Can you post the output from the original CHECKDB that prompted you to run repair? I need to see the error state numbers to tell you what's wrong.ThanksPaul 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 : 16:15:28
|
| We are on 8.00.929. I dont have the output from the original output. We were running it from a job since the DB is so large. I am in QA running DBCC CHECKDB interactivilly now. I will post the output. |
|
|
|
cgunner
Yak Posting Veteran
95 Posts |
Posted - 2005-08-17 : 09:32:13
|
| We had over 600 tables that did not get repaired. It stated on the out put to run repair rebuild option. That did not help much either. We are more than likely going to have to do a restore. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-17 : 10:46:55
|
quote:
Originally posted by cgunner
We had over 600 tables that did not get repaired. It stated on the out put to run repair rebuild option. That did not help much either. We are more than likely going to have to do a restore.
Cna you post (or email me) the full output from repair? I can't help you without this information.ThanksPaul 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-18 : 08:03:52
|
| I would have to email it. It is about a 2 meg file. The command ran for 30 hours. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-18 : 11:11:57
|
quote:
Originally posted by cgunner
I would have to email it. It is about a 2 meg file. The command ran for 30 hours.
Go for it.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-18 : 12:34:02
|
| Just sent it. |
|
|
|
|
|
|
|
|
DBCC CHECKDB failing