SQL Server Performance Forum – Threads Archive

DBCC DBCHECK

10 PM in BsAs. A new client call me to try to fix some problem in SQL 7.0 Sp2. Maintenance plan has reported 600 asignation errors and 0 consistence errors. I try DBCC DBCHECK REPAIR_REBUILD and still errors. Last good backup from 10/9, because Maintenace plan run on wensday and sunday, and on wensday was ok. I intent to run DBCC DBCHECK REPAIR_ALLOW_DATA_LOSS, until restore last good backup. Any recomendations? Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

Are you able to restore Sat-Thu backups in turn to a different name, running DBCC DBCHECK on each? This may give you a later last good backup… repair_allow_data_loss is likely to corrupt you data, so I’d only use this if you had no other choice… Are the errors localised to a particular table/index, etc? Cheers
Twan

Twan: This is my first time in that client. I found no space at all (500 Mb free), 20Gb DataBase.
Backup is runnig on DTS, and no room to get paralel copy on disk.
This morning about 1 AM, finally I run DBCC with repair_……, and 653 asignation errors where fixed, and 16 consistency errors where fixed too. But also DBCC inform some errors about AIM, GIM and others. (I’m in home now and donÂ´t have details), I think the only way is to restore Th Backup and this was my recomendation. I donÂ´t know yet what will be the cliente decition. I suppose I found out during this day. Report does not inform particulars tables or index. Thanks Twan, Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

What was the exact error after that maint.plan executed?
Also suggest to test and apply SP4 on thier installation. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Satya: Here is: Server: Msg 8906, Level 16, State 1, Line 0 Page (1:2275919) in database ID 7 is allocated in the SGAM (1:2044929) and PFS (1:227272<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />, but was not allocated in any IAM. PFS flags ‘IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL’. Follow n-lines: Server: Msg 8905, Level 16, State 1, Line 0 Extent (1:2388896) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it. At end: CHECKDB ha encontrado 673 errores de asignaciÃ³n y 16 errores de consistencia en la base de datos ‘VESTIDITOS’. CHECKDB ha arreglado 673 errores de asignaciÃ³n y 16 errores de consistencia en la base de datos ‘VESTIDITOS’. Means: CHECKDB has found 673 asignation errors and 16 consistence (spell?) errors in data base VESTIDITOS. CHECKDB has fix 673 asignation errors…….. I suggest the same to client, but I don’t know if doing this will fix the problem. Is, how can I said, Argentina’s way. Is a big company and no DBA at all and so on. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true. Bertrand Russell

Refer this KBA<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;EN-US;278366>http://support.microsoft.com/default.aspx?scid=kb;EN-US;278366</a> for errors 8905 & 8906 and suggest to upgrade to latest SP on SQL SErver which will prevent most of the issues. And get more bucks out of it [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] _________ Satya SKJ Moderator SQL-Server-Performance.Com

Thanks Satya, I send this to "IT Manager"…… BTW: I have to find in dictionay what bucks means. Very nice!!! Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

General term of buck means… jumps and I mean to say you get more $$ or your currency out of it.
Good luck [8D] _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>