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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Suspect database

Author  Topic 

psilva
Starting Member

3 Posts

Posted - 2007-04-12 : 10:55:04
Hi everyone,
I hope you could help me.
I have a database that was marked as suspect, i change is state but now i want to extract the information of the database and a couldn't because de database have several erros include 2 allocation erros.
How could i solve this problem? I don't have a recent database backup.
thanks to everyone.

Pedro Silva

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-12 : 11:06:36
Did you find any disk related issue on the server? Sometimes rebooting solves db suspect caused by disk issue.
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-04-12 : 13:40:37
Can you post the results of
DBCC CHECKDB (your dbname) WITH NO_INFOMSGS 
over in the data corruption forum? Sometimes MS folks wander through there. You may get a fix, but if you don't:

As for getting the data out, create a brand new database, create all the tables over there with no foreign keys, and use the export dat wizard to get it out. If you have no errors getting the data out, you should be fine. Reinstate all the foreign keys, rename the old and new databases, and you should be able to get along from there.....with backups, of course.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-04-12 : 16:57:17
"As for getting the data out ...."

You might also like to look at: "How I Rescue Data from Corrupted Databases" : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80160
Go to Top of Page

psilva
Starting Member

3 Posts

Posted - 2007-04-13 : 06:43:43
Hi

This is the result of yhe DBCC CHECKDB

Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1536700). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1536708). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1536711). The PageId in the page header = (0:0).
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1536712) in database ID 8 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1536712). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:1536723). The PageId in the page header = (0:0).
DBCC results for 'DBSistema'.
CHECKDB found 1 allocation errors and 5 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 1288 rows in 25 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1178 rows in 52 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1634 rows in 25 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 792 rows in 39 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 209 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 458 rows in 3 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 247 rows in 2 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'TabTaxasTT'.
There are 308 rows in 1 pages for object 'TabTaxasTT'.
DBCC results for 'TabelaSessoes'.
There are 0 rows in 0 pages for object 'TabelaSessoes'.
DBCC results for 'LogAgExec'.
There are 3672 rows in 97 pages for object 'LogAgExec'.
DBCC results for 'TabTribRef'.
There are 796 rows in 4 pages for object 'TabTribRef'.
DBCC results for 'TBAcidente'.
There are 0 rows in 1 pages for object 'TBAcidente'.
DBCC results for 'AcessosUtil'.
There are 69408 rows in 193 pages for object 'AcessosUtil'.
DBCC results for 'Actos Processuais'.
There are 132697 rows in 3004 pages for object 'Actos Processuais'.
DBCC results for 'TabUtilRef'.
There are 11926 rows in 30 pages for object 'TabUtilRef'.
DBCC results for 'Agendamentos'.
There are 73596 rows in 1946 pages for object 'Agendamentos'.
DBCC results for 'TabTextoRef'.
There are 10 rows in 1 pages for object 'TabTextoRef'.
DBCC results for 'AProcessuais'.
There are 35 rows in 2 pages for object 'AProcessuais'.
DBCC results for 'Contadores Anuais'.
There are 61 rows in 2 pages for object 'Contadores Anuais'.
DBCC results for 'IntervCondenacao'.
There are 6651 rows in 249 pages for object 'IntervCondenacao'.
DBCC results for 'TabUnOrgRef'.
There are 3173 rows in 13 pages for object 'TabUnOrgRef'.
DBCC results for 'Contadores Gerais'.
There are 1 rows in 1 pages for object 'Contadores Gerais'.
DBCC results for 'ProcessosSessao'.
There are 0 rows in 0 pages for object 'ProcessosSessao'.
DBCC results for 'CrimEnquad'.
There are 14 rows in 2 pages for object 'CrimEnquad'.
DBCC results for 'Dias Excluidos'.
There are 464 rows in 2 pages for object 'Dias Excluidos'.
DBCC results for 'EntNotadoras'.
There are 2192 rows in 11 pages for object 'EntNotadoras'.
DBCC results for 'Contadores'.
There are 4 rows in 1 pages for object 'Contadores'.
DBCC results for 'Especies Distribuicao'.
There are 106 rows in 2 pages for object 'Especies Distribuicao'.
DBCC results for 'dtproperties'.
There are 7 rows in 1 pages for object 'dtproperties'.
DBCC results for 'Especies Processos'.
There are 503 rows in 9 pages for object 'Especies Processos'.
DBCC results for 'TBInterv'.
There are 0 rows in 1 pages for object 'TBInterv'.
DBCC results for 'Paises'.
There are 225 rows in 3 pages for object 'Paises'.
DBCC results for 'TabUnOrgProp'.
There are 59 rows in 1 pages for object 'TabUnOrgProp'.
DBCC results for 'IntervDesignacao'.
There are 108 rows in 2 pages for object 'IntervDesignacao'.
DBCC results for 'LogDistrib'.
There are 6639 rows in 36 pages for object 'LogDistrib'.
DBCC results for 'IntervCrimeImp'.
There are 24795 rows in 689 pages for object 'IntervCrimeImp'.
DBCC results for 'ProcDepende'.
There are 5289 rows in 68 pages for object 'ProcDepende'.
DBCC results for 'TabUtilTrib'.
There are 70 rows in 1 pages for object 'TabUtilTrib'.
DBCC results for 'MCCRef'.
There are 214 rows in 5 pages for object 'MCCRef'.
DBCC results for 'TabObjAccao'.
There are 35204 rows in 94 pages for object 'TabObjAccao'.
DBCC results for 'NivComplex'.
There are 93 rows in 5 pages for object 'NivComplex'.
DBCC results for 'ObjDestino'.
There are 6 rows in 2 pages for object 'ObjDestino'.
DBCC results for 'PagamentosRef'.
There are 8 rows in 2 pages for object 'PagamentosRef'.
DBCC results for 'ProcEstadosRef'.
There are 128 rows in 2 pages for object 'ProcEstadosRef'.
DBCC results for 'TBIntervVal'.
There are 0 rows in 1 pages for object 'TBIntervVal'.
DBCC results for 'Programas'.
There are 81 rows in 2 pages for object 'Programas'.
DBCC results for 'Agenda'.
There are 7658 rows in 24 pages for object 'Agenda'.
DBCC results for 'CTTValores'.
There are 1 rows in 1 pages for object 'CTTValores'.
DBCC results for 'LogEncPapeis'.
There are 650 rows in 5 pages for object 'LogEncPapeis'.
DBCC results for 'CTTRegistos'.
There are 83364 rows in 188 pages for object 'CTTRegistos'.
DBCC results for 'Servidores'.
There are 3 rows in 1 pages for object 'Servidores'.
DBCC results for 'AgendaDetalhes'.
There are 71932 rows in 1736 pages for object 'AgendaDetalhes'.
DBCC results for 'TabQualidade'.
There are 3969 rows in 57 pages for object 'TabQualidade'.
DBCC results for 'TabUnOrg'.
There are 1640 rows in 15 pages for object 'TabUnOrg'.
Server: Msg 2515, Level 16, State 1, Line 1
Page (1:1243988), object ID 630293305, index ID 8 has been modified but is not marked modified in the differential backup bitmap.
DBCC results for 'TabUtilTribUnOrg'.
There are 139 rows in 1 pages for object 'TabUtilTribUnOrg'.
DBCC results for 'EspeciesFases'.
There are 10287 rows in 28 pages for object 'EspeciesFases'.
DBCC results for 'Tjustica'.
There are 76 rows in 1 pages for object 'Tjustica'.
DBCC results for 'Tribunais'.
There are 32 rows in 2 pages for object 'Tribunais'.
DBCC results for 'Unidades'.
There are 6 rows in 1 pages for object 'Unidades'.
DBCC results for 'TabUtilModulos'.
There are 237 rows in 3 pages for object 'TabUtilModulos'.
DBCC results for 'Unidades Organicas'.
There are 10 rows in 2 pages for object 'Unidades Organicas'.
DBCC results for 'EntidadeDetalhes'.
There are 2838388 rows in 43785 pages for object 'EntidadeDetalhes'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'EntidadeDetalhes' (object ID 630293305).
DBCC results for 'AgendaResult'.
There are 4562 rows in 12 pages for object 'AgendaResult'.
DBCC results for 'Zonas'.
There are 24 rows in 1 pages for object 'Zonas'.
DBCC results for 'CaractActos'.
There are 763704 rows in 2643 pages for object 'CaractActos'.
DBCC results for 'TabUtilAcessos'.
There are 121 rows in 1 pages for object 'TabUtilAcessos'.
DBCC results for 'CrimSubEnquad'.
There are 88 rows in 4 pages for object 'CrimSubEnquad'.
DBCC results for 'Distribuicao'.
There are 125 rows in 2 pages for object 'Distribuicao'.
DBCC results for 'ActosSenha'.
There are 4 rows in 1 pages for object 'ActosSenha'.
DBCC results for 'Entidades'.
There are 899780 rows in 31281 pages for object 'Entidades'.
DBCC results for 'Esp_Trib'.
There are 881 rows in 4 pages for object 'Esp_Trib'.
DBCC results for 'NotasHonorarios'.
There are 537 rows in 6 pages for object 'NotasHonorarios'.
DBCC results for 'EspecieInterv'.
There are 8416 rows in 23 pages for object 'EspecieInterv'.
DBCC results for 'TabTextoUtil'.
There are 26 rows in 2 pages for object 'TabTextoUtil'.
DBCC results for 'LogTransf'.
There are 592 rows in 36 pages for object 'LogTransf'.
DBCC results for 'EspIntervPainel'.
There are 55362 rows in 164 pages for object 'EspIntervPainel'.
DBCC results for 'Historico'.
There are 1249 rows in 11 pages for object 'Historico'.
DBCC results for 'Digitalizacao'.
There are 0 rows in 0 pages for object 'Digitalizacao'.
DBCC results for 'DistMag'.
There are 2587 rows in 20 pages for object 'DistMag'.
DBCC results for 'AtalhosUtilizador'.
There are 44 rows in 2 pages for object 'AtalhosUtilizador'.
DBCC results for 'AProcEstados'.
There are 856 rows in 3 pages for object 'AProcEstados'.
DBCC results for 'Tipos Partes'.
There are 990 rows in 7 pages for object 'Tipos Partes'.
DBCC results for 'CPostal'.
There are 1252 rows in 2 pages for object 'CPostal'.
DBCC results for 'Título Actos'.
There are 14933 rows in 167 pages for object 'Título Actos'.
DBCC results for 'Adjuntos'.
There are 0 rows in 0 pages for object 'Adjuntos'.
DBCC results for 'UnOrgDist'.
There are 8652 rows in 49 pages for object 'UnOrgDist'.
DBCC results for 'SalasAudiencia'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_1' (ID 949578421) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:993669:601) with values (Oculto = 1.345303099E-284) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 949578421, index ID 5. Page (1:1535682) is missing a reference from previous page (1:995130). Possible chain linkage problem.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_3' (ID 949578421) (index ID 6). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:997529:382) with values (IDEntidade = 0) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_3' (ID 949578421) (index ID 6). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:997529:383) with values (IDEntidade = 0) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_3' (ID 949578421) (index ID 6). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:997529:384) with values (IDEntidade = 0) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_3' (ID 949578421) (index ID 6). Extra or invalid key for the keys:
There are 0 rows in 0 pages for object 'SalasAudiencia'.
DBCC results for 'Utilizadores'.
There are 117 rows in 5 pages for object 'Utilizadores'.
DBCC results for 'Acessos'.
There are 430 rows in 2 pages for object 'Acessos'.
DBCC results for 'TabErros'.
There are 566 rows in 12 pages for object 'TabErros'.
DBCC results for 'DistUnOrgMag'.
There are 22 rows in 1 pages for object 'DistUnOrgMag'.
DBCC results for 'Actos'.
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1001720:167) with values (IDEntidade = 764270) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_3' (ID 949578421) (index ID 6). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1385641:165) with values (IDEntidade = 869497) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_3' (ID 949578421) (index ID 6). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1407514:39) with values (IDEntidade = 183015) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_4' (ID 949578421) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1340464:207) with values (Mail = 0) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_4' (ID 949578421) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1340464:208) with values (Mail = 0) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_4' (ID 949578421) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1340464:209) with values (Mail = 0) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_4' (ID 949578421) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1340464:210) with values (Mail = 0) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_4' (ID 949578421) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1340464:211) with values (Mail = 0) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_4' (ID 949578421) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1340464:212) with values (Mail = 0) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_5' (ID 949578421) (index ID 8). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1007865:534) with values (IDQualidade = 0) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_5' (ID 949578421) (index ID 8). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1007865:535) with values (IDQualidade = 0) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_5' (ID 949578421) (index ID 8). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1007865:536) with values (IDQualidade = 0) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_5' (ID 949578421) (index ID 8). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1008542:7) with values (IDQualidade = 19) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_5' (ID 949578421) (index ID 8). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1008733:118) with values (IDQualidade = 20) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_5' (ID 949578421) (index ID 8). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1008956:44) with values (IDQualidade = 22) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_6' (ID 949578421) (index ID 9). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:853448:435) with values (IDProcesso = 66700) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_6' (ID 949578421) (index ID 9). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1012259:106) with values (IDProcesso = 43344) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_6' (ID 949578421) (index ID 9). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1012888:307) with values (IDProcesso = 65749) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_6' (ID 949578421) (index ID 9). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1012896:63) with values (IDProcesso = 66147) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_6' (ID 949578421) (index ID 9). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1386888:15) with values (IDProcesso = 70335) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_6' (ID 949578421) (index ID 9). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1502255:214) with values (IDProcesso = 74408) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_7' (ID 949578421) (index ID 10). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1523408:292) with values (Data = Apr 12 2007 12:00AM) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_7' (ID 949578421) (index ID 10). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1523408:293) with values (Data = Apr 12 2007 12:00AM) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_7' (ID 949578421) (index ID 10). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1535505:57) with values (Data = Apr 13 2007 12:00AM) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_7' (ID 949578421) (index ID 10). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1535506:87) with values (Data = Apr 11 2007 12:00AM) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_7' (ID 949578421) (index ID 10). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1535506:88) with values (Data = Apr 11 2007 12:00AM) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_7' (ID 949578421) (index ID 10). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1535506:89) with values (Data = Apr 11 2007 12:00AM) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_8' (ID 949578421) (index ID 11). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1018767:321) with values (Acto = 49022) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_8' (ID 949578421) (index ID 11). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1018912:319) with values (Acto = 49357) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_8' (ID 949578421) (index ID 11). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1019043:264) with values (Acto = 51440) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_8' (ID 949578421) (index ID 11). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1019714:446) with values (Acto = 96376) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_8' (ID 949578421) (index ID 11). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1389951:114) with values (Acto = 78410) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_8' (ID 949578421) (index ID 11). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1514528:197) with values (Acto = 46558) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_12' (ID 949578421) (index ID 15). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:640821:484) with values (CTT = 7.292902716E-304) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_12' (ID 949578421) (index ID 15). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:640821:485) with values (CTT = 4.779476724E-299) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_13' (ID 949578421) (index ID 18). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:731321:50) with values (IDNacional = '288CC28A-D4EF-4DC7-9A21-9806D787DAA4') points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_13' (ID 949578421) (index ID 18). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:846965:18) with values (IDNacional = 'DC3CFE0B-4004-47A9-8B44-1610D01A1688') points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_13' (ID 949578421) (index ID 18). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1359178:49) with values (IDNacional = 'A4667012-F324-41AC-A904-2C4720938F96') points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_13' (ID 949578421) (index ID 18). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1370322:12) with values (IDNacional = '62201662-70BB-469B-B5CE-30EC549436D7') points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_13' (ID 949578421) (index ID 18). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1498282:11) with values (IDNacional = '43E97741-EF41-4A22-9CCC-BBEAC10705D5') points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_13' (ID 949578421) (index ID 18). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1510827:4) with values (IDNacional = 'A9B37F4F-A3B0-43D2-A71A-8A0A5B46CADA') points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_IDUtilRef' (ID 949578421) (index ID 24). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:899338:426) with values (IDUtilRef = 78517) points to the data row identified by (RID = (1:1536656:1)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_IDUtilRef' (ID 949578421) (index ID 24). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:899697:176) with values (IDUtilRef = 78519) points to the data row identified by (RID = (1:1536656:3)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_IDUtilRef' (ID 949578421) (index ID 24). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:903681:205) with values (IDUtilRef = 78539) points to the data row identified by (RID = (1:1536656:5)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_IDUtilRef' (ID 949578421) (index ID 24). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:905510:89) with values (IDUtilRef = 85469) points to the data row identified by (RID = (1:1536656:6)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_IDUtilRef' (ID 949578421) (index ID 24). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1341258:113) with values (IDUtilRef = 78511) points to the data row identified by (RID = (1:1536656:2)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Actos.IX_Actos_IDUtilRef' (ID 949578421) (index ID 24). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1501861:142) with values (IDUtilRef = 84169) points to the data row identified by (RID = (1:1536656:4)).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Processos.IX_Processos_DMov' (ID 969770512) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1533387:44) with values (DMov = Apr 10 2007 12:00AM and NProcesso = '1659/06.0TBFIG' and ? = NULL) points to the data row identified by ().
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Processos' (ID 969770512). Missing or invalid key in index 'IX_Processos_nActo' (ID 13) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:150505:17) identified by (RID = (1:150505:17) NProcesso = '115/06.1GCFIG' and ? = 5) has index values (nActo = 1890527 and NProcesso = '115/06.1GCFIG' and ? = 5).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Processos.IX_Processos_nActo' (ID 969770512) (index ID 13). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1528382:15) with values (nActo = 1886486 and NProcesso = '141/07.3PBFIG' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Processos.IX_Processos_nActo' (ID 969770512) (index ID 13). Extra or invalid key for the keys:
There are 1541404 rows in 29704 pages for object 'Actos'.
CHECKDB found 0 allocation errors and 52 consistency errors in table 'Actos' (object ID 949578421).
DBCC results for 'HabilusOpcoes'.
There are 2 rows in 1 pages for object 'HabilusOpcoes'.
DBCC results for 'AZonaUtil'.
There are 96 rows in 2 pages for object 'AZonaUtil'.
DBCC results for 'Processos'.
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1531331:88) with values (nActo = 1890485 and NProcesso = '818/06.0PBFIG' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Processos.IX_Processos_nActo' (ID 969770512) (index ID 13). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1531331:91) with values (nActo = 1890491 and NProcesso = '115/06.1GCFIG' and ? = 5) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'DBSistema', index 'Processos.IX_Processos_nActo' (ID 969770512) (index ID 13). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:1531331:97) with values (nActo = 1890518 and NProcesso = '1161/06.0PBFIG' and ? = 1) points to the data row identified by ().
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 969770512, index ID 22: Page (1:894261) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 969770512, index ID 22, page (1:894261), row 0. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Registo Papeis' (ID 976722532). Missing or invalid key in index 'IX_Registo Papeis_11' (ID 13) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:1535579:7) identified by (RID = (1:1535579:7) Ordem_Papeis = 0 and ? = 373600) has index values (Tipo_Papel = 30005 and Ordem_Papeis = 0 and ? = 373600).
There are 61893 rows in 3542 pages for object 'Processos'.
CHECKDB found 0 allocation errors and 8 consistency errors in table 'Processos' (object ID 969770512).
DBCC results for 'ProcessamentoGPLP'.
There are 0 rows in 0 pages for object 'ProcessamentoGPLP'.
DBCC results for 'Registo Papeis'.
There are 407972 rows in 11275 pages for object 'Registo Papeis'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'Registo Papeis' (object ID 976722532).
DBCC results for 'BlocoNotas'.
There are 4413 rows in 253 pages for object 'BlocoNotas'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1061578820, index ID 1. Page (1:1535183) is missing a reference from previous page (1:1122765). Possible chain linkage problem.
Server: Msg 2575, Level 16, State 1, Line 1
IAM page (1:1521036) is pointed to by the next pointer of IAM page (1:813010) object ID 1061578820 index ID 6 but was not detected in the scan.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1061578820, index ID 6: Page (1:1536712) could not be processed. See other errors for details.
DBCC results for 'ProcessosErros'.
There are 0 rows in 0 pages for object 'ProcessosErros'.
DBCC results for 'FlagDistrib'.
There are 8542 rows in 22 pages for object 'FlagDistrib'.
DBCC results for 'Creditos'.
There are 890 rows in 18 pages for object 'Creditos'.
DBCC results for 'Impedimentos'.
There are 0 rows in 0 pages for object 'Impedimentos'.
DBCC results for 'CrimeTipo'.
There are 1206 rows in 34 pages for object 'CrimeTipo'.
DBCC results for 'ProcessosDetalhes'.
There are 267219 rows in 3978 pages for object 'ProcessosDetalhes'.
DBCC results for 'Intervenientes'.
There are 268872 rows in 8563 pages for object 'Intervenientes'.
CHECKDB found 1 allocation errors and 2 consistency errors in table 'Intervenientes' (object ID 1061578820).
DBCC results for 'MagDist'.
There are 1919 rows in 34 pages for object 'MagDist'.
DBCC results for 'TabAnexos'.
There are 0 rows in 0 pages for object 'TabAnexos'.
DBCC results for 'MagUnOrg'.
There are 42 rows in 3 pages for object 'MagUnOrg'.
DBCC results for 'LogEntidades'.
There are 9769 rows in 240 pages for object 'LogEntidades'.
DBCC results for 'Moradas'.
There are 976713 rows in 28385 pages for object 'Moradas'.
DBCC results for 'MagAntiguidade'.
There are 0 rows in 0 pages for object 'MagAntiguidade'.
DBCC results for 'Precatorias'.
There are 13435 rows in 321 pages for object 'Precatorias'.
DBCC results for 'RefTabDocs'.
There are 0 rows in 0 pages for object 'RefTabDocs'.
DBCC results for 'ProcEstados'.
There are 76342 rows in 1179 pages for object 'ProcEstados'.
DBCC results for 'LogEspecies'.
There are 1424 rows in 15 pages for object 'LogEspecies'.
DBCC results for 'ProcNumera'.
There are 0 rows in 0 pages for object 'ProcNumera'.
DBCC results for 'Contas Correntes'.
There are 8158 rows in 292 pages for object 'Contas Correntes'.
DBCC results for 'IntervCrime'.
There are 17005 rows in 347 pages for object 'IntervCrime'.
DBCC results for 'TABBens'.
There are 3942 rows in 97 pages for object 'TABBens'.
DBCC results for 'IntervMCC'.
There are 4167 rows in 214 pages for object 'IntervMCC'.
DBCC results for 'LogErros'.
There are 0 rows in 0 pages for object 'LogErros'.
DBCC results for 'ProcReDist'.
There are 0 rows in 0 pages for object 'ProcReDist'.
DBCC results for 'IntervOutProc'.
There are 289 rows in 9 pages for object 'IntervOutProc'.
DBCC results for 'ObjRegisto'.
There are 1801 rows in 85 pages for object 'ObjRegisto'.
DBCC results for 'ObjRegDestino'.
There are 1100 rows in 17 pages for object 'ObjRegDestino'.
DBCC results for 'TabPostIt'.
There are 1 rows in 1 pages for object 'TabPostIt'.
DBCC results for 'PagamentosDetalhe'.
There are 8315 rows in 142 pages for object 'PagamentosDetalhe'.
DBCC results for 'LogProcTransf'.
There are 4319 rows in 8 pages for object 'LogProcTransf'.
DBCC results for 'LogConsMag'.
There are 0 rows in 0 pages for object 'LogConsMag'.
DBCC results for 'HabilusAudit'.
There are 17661 rows in 531 pages for object 'HabilusAudit'.
DBCC results for 'HabilusConfig'.
There are 120 rows in 2 pages for object 'HabilusConfig'.
DBCC results for 'ProcIndiceRef'.
There are 2161 rows in 7 pages for object 'ProcIndiceRef'.
DBCC results for 'ProcessosBens'.
There are 6914 rows in 181 pages for object 'ProcessosBens'.
DBCC results for 'DespMagRef'.
There are 0 rows in 0 pages for object 'DespMagRef'.
DBCC results for 'LogHabilus'.
There are 6397 rows in 279 pages for object 'LogHabilus'.
DBCC results for 'TabMsg'.
There are 345 rows in 8 pages for object 'TabMsg'.
DBCC results for 'ActosMagRef'.
There are 2690 rows in 9 pages for object 'ActosMagRef'.
DBCC results for 'MsgHabilus'.
There are 7225 rows in 24 pages for object 'MsgHabilus'.
DBCC results for 'ProcAgregados'.
There are 0 rows in 0 pages for object 'ProcAgregados'.
DBCC results for 'ProcIndice'.
There are 487 rows in 7 pages for object 'ProcIndice'.
DBCC results for 'IntervPresos'.
There are 266 rows in 8 pages for object 'IntervPresos'.
DBCC results for 'ProcUtil'.
There are 0 rows in 0 pages for object 'ProcUtil'.
DBCC results for 'TabArquivo'.
There are 14994 rows in 255 pages for object 'TabArquivo'.
DBCC results for 'UtilConsultas'.
There are 127 rows in 8 pages for object 'UtilConsultas'.
DBCC results for 'EntidadeBem'.
There are 6410 rows in 119 pages for object 'EntidadeBem'.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1789249429: Errors found in text ID 45712539648 owned by data record identified by RID = (1:1535592:9).
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 1789249429: Errors found in text ID 45712408576 owned by data record identified by RID = (1:1535595:42).
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1789249429, index ID 255: Page (1:1536700) could not be processed. See other errors for details.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 1789249429. The text, ntext, or image node at page (1:1536703), slot 0, text ID 45712408576 does not match its reference from page (1:1536691), slot 1.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 1789249429. The text, ntext, or image node at page (1:1536707), slot 0, text ID 45712539648 does not match its reference from page (1:1536697), slot 2.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1789249429, index ID 255: Page (1:1536708) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1789249429, index ID 255: Page (1:1536711) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1789249429, index ID 255: Page (1:1536723) could not be processed. See other errors for details.
DBCC results for 'LogActosMag'.
There are 452 rows in 2 pages for object 'LogActosMag'.
DBCC results for 'LogActosAgregados'.
There are 0 rows in 0 pages for object 'LogActosAgregados'.
DBCC results for 'ActosMag'.
There are 507 rows in 9 pages for object 'ActosMag'.
DBCC results for 'LogUtil'.
There are 18678 rows in 96 pages for object 'LogUtil'.
DBCC results for 'VariaveisLista'.
There are 265 rows in 3 pages for object 'VariaveisLista'.
DBCC results for 'MapaDistritosJudiciais'.
There are 5 rows in 1 pages for object 'MapaDistritosJudiciais'.
DBCC results for 'LogConsultasUtil'.
There are 26421 rows in 143 pages for object 'LogConsultasUtil'.
DBCC results for 'TabDocs'.
There are 339202 rows in 6716 pages for object 'TabDocs'.
CHECKDB found 0 allocation errors and 8 consistency errors in table 'TabDocs' (object ID 1789249429).
DBCC results for 'MapaCirculosJudiciais'.
There are 59 rows in 1 pages for object 'MapaCirculosJudiciais'.
DBCC results for 'VUsadas'.
There are 1282620 rows in 4193 pages for object 'VUsadas'.
DBCC results for 'MapaComarcas'.
There are 234 rows in 2 pages for object 'MapaComarcas'.
DBCC results for 'LogConsultas'.
There are 3204 rows in 103 pages for object 'LogConsultas'.
DBCC results for 'SubsidiosRef'.
There are 17 rows in 1 pages for object 'SubsidiosRef'.
DBCC results for 'SalariosRef'.
There are 16 rows in 2 pages for object 'SalariosRef'.
DBCC results for 'MapaMunicipios'.
There are 306 rows in 2 pages for object 'MapaMunicipios'.
DBCC results for 'NomesProprios'.
There are 5349 rows in 21 pages for object 'NomesProprios'.
DBCC results for 'MapaFreguesias'.
There are 4270 rows in 46 pages for object 'MapaFreguesias'.
DBCC results for 'ProcSubsidios'.
There are 0 rows in 1 pages for object 'ProcSubsidios'.
DBCC results for 'PropActos'.
There are 197701 rows in 705 pages for object 'PropActos'.
DBCC results for 'SessoesConfig'.
There are 21 rows in 1 pages for object 'SessoesConfig'.
DBCC results for 'IntervDetalhes'.
There are 73373 rows in 1177 pages for object 'IntervDetalhes'.
DBCC results for 'RelPapel'.
There are 1199 rows in 4 pages for object 'RelPapel'.
CHECKDB found 2 allocation errors and 77 consistency errors in database 'DBSistema'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DBSistema ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


could i recover this database?
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-04-13 : 09:33:45
Not entirely, I believe. Many of the errors are in indexes, which do not affect the actual data, but at least 2 errors in EntidadeBem lead me to think that the data in the text field(s) has already been lost. Due to the sheer number of errors, I would just restore from a backup.
Go to Top of Page

psilva
Starting Member

3 Posts

Posted - 2007-04-13 : 10:00:44
the backup i have is old....
i need to recover this database because of that.
there are now big problem if i lose a few data

thanks
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-04-13 : 14:20:14
You can try posting this question in the Data Corruption forum, but like I said, you are more than likely looking at some data loss. The best I can estimate is that you have only really lost the text/image fields(s) from 2 rows. You may want to take a backup of this database, restore it to another machine, and run the dbcc checkdb with allow_data_loss to see what you are actually going to lose.
Go to Top of Page
   

- Advertisement -