Database / DBCC Help!!!

Jun 6, 2008

I have a one database that appears to have some corruption but being new to SQL 2005 I can't seem to find the problem, only a bunch of stack dumps and DBCC doesn't appear to return the results I would expect.

DBCC CHECKDB (MYDB) WITH ALL_ERRORMSGS, NO-INFOMSGS

Msg 211, Level 23, State 51, Line 2
Possible schema corruption. Ru DBCC CheckCatalog.
Msg 0, level 20, State 0, line 0
A severe error occurred on the current command. The results should be discard

DBCC CHECKCATALOG (MYDB)

DBCC execution completed. If DBCC printed error messages, contact your system administrator

Stack Dump

06/06/2008 08:45:58,spid187,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/06/2008 08:45:56,spid187,Unknown,Stack Signature for the dump is 0x4E678B02
06/06/2008 08:45:56,spid187,Unknown,* -------------------------------------------------------------------------------
06/06/2008 08:45:56,spid187,Unknown,78132A47 Module(MSVCR80+00002A47)
06/06/2008 08:45:56,spid187,Unknown,781329BB Module(MSVCR80+000029BB)
06/06/2008 08:45:56,spid187,Unknown,010B9201 Module(sqlservr+000B9201)
06/06/2008 08:45:56,spid187,Unknown,010B9064 Module(sqlservr+000B9064)
06/06/2008 08:45:56,spid187,Unknown,010B939C Module(sqlservr+000B939C)
06/06/2008 08:45:56,spid187,Unknown,010B94A5 Module(sqlservr+000B94A5)
06/06/2008 08:45:56,spid187,Unknown,010075DC Module(sqlservr+000075DC)
06/06/2008 08:45:56,spid187,Unknown,010078CC Module(sqlservr+000078CC)
06/06/2008 08:45:56,spid187,Unknown,010077A6 Module(sqlservr+000077A6)
06/06/2008 08:45:56,spid187,Unknown,0102F1F4 Module(sqlservr+0002F1F4)
06/06/2008 08:45:56,spid187,Unknown,01032A36 Module(sqlservr+00032A36)
06/06/2008 08:45:56,spid187,Unknown,01028600 Module(sqlservr+00028600)
06/06/2008 08:45:56,spid187,Unknown,0134752A Module(sqlservr+0034752A)
06/06/2008 08:45:56,spid187,Unknown,01430633 Module(sqlservr+00430633)
06/06/2008 08:45:56,spid187,Unknown,01346B6B Module(sqlservr+00346B6B)
06/06/2008 08:45:56,spid187,Unknown,013A929A Module(sqlservr+003A929A)
06/06/2008 08:45:56,spid187,Unknown,01368BB2 Module(sqlservr+00368BB2)
06/06/2008 08:45:56,spid187,Unknown,013A9BDC Module(sqlservr+003A9BDC)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,0131F5C0 Module(sqlservr+0031F5C0)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,0131F721 Module(sqlservr+0031F721)
06/06/2008 08:45:56,spid187,Unknown,01320085 Module(sqlservr+00320085)
06/06/2008 08:45:56,spid187,Unknown,013A9A04 Module(sqlservr+003A9A04)
06/06/2008 08:45:56,spid187,Unknown,01369B63 Module(sqlservr+00369B63)
06/06/2008 08:45:56,spid187,Unknown,0136A2D8 Module(sqlservr+0036A2D8)
06/06/2008 08:45:56,spid187,Unknown,0136A1B4 Module(sqlservr+0036A1B4)
06/06/2008 08:45:56,spid187,Unknown,0136A071 Module(sqlservr+0036A071)
06/06/2008 08:45:56,spid187,Unknown,013AD9F3 Module(sqlservr+003AD9F3)
06/06/2008 08:45:56,spid187,Unknown,013AD7EB Module(sqlservr+003AD7EB)
06/06/2008 08:45:56,spid187,Unknown,013AD6FB Module(sqlservr+003AD6FB)
06/06/2008 08:45:56,spid187,Unknown,013B50A3 Module(sqlservr+003B50A3)
06/06/2008 08:45:56,spid187,Unknown,012FB17F Module(sqlservr+002FB17F)
06/06/2008 08:45:56,spid187,Unknown,012FBE95 Module(sqlservr+002FBE95)
06/06/2008 08:45:56,spid187,Unknown,012FBDDB Module(sqlservr+002FBDDB)
06/06/2008 08:45:56,spid187,Unknown,011A06A5 Module(sqlservr+001A06A5)
06/06/2008 08:45:56,spid187,Unknown,01482AB3 Module(sqlservr+00482AB3)
06/06/2008 08:45:56,spid187,Unknown,01443470 Module(sqlservr+00443470)
06/06/2008 08:45:56,spid187,Unknown,015BFA3D Module(sqlservr+005BFA3D)
06/06/2008 08:45:56,spid187,Unknown,021A642D Module(sqlservr+011A642D)
06/06/2008 08:45:56,spid187,Unknown,021A6880 Module(sqlservr+011A6880)
06/06/2008 08:45:56,spid187,Unknown,021A29C4 Module(sqlservr+011A29C4)
06/06/2008 08:45:56,spid187,Unknown,77E4BEE7 Module(kernel32+0000BEE7)
06/06/2008 08:45:56,spid187,Unknown,* Short Stack Dump
06/06/2008 08:45:56,spid187,Unknown,* -------------------------------------------------------------------------------
06/06/2008 08:45:56,spid187,Unknown,* *******************************************************************************
06/06/2008 08:45:56,spid187,Unknown,* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
06/06/2008 08:45:56,spid187,Unknown,* Esp: 664DD540: 0B74D5C0 000042AC 00000000 00000000 77E4BEE7 00000000
06/06/2008 08:45:56,spid187,Unknown,* EFlags: 00000246:
06/06/2008 08:45:56,spid187,Unknown,* SegCs: 664D001B: 00000000 00000100 FFFFFE00 FFFFFFFF FFFFFFFF FFFFFFFF
06/06/2008 08:45:56,spid187,Unknown,* Ebp: 664DD594: 664DD5D8 021A29C4 000042AC 00000000 00000000 00000000
06/06/2008 08:45:56,spid187,Unknown,* Eip: 77E4BEE7: 10C2C95E 01093D00 840FC000 00000095 F29DE950 9090FFFF
06/06/2008 08:45:56,spid187,Unknown,* Edx: FFFFFFFF:
06/06/2008 08:45:56,spid187,Unknown,* Ecx: 664DDBB4: 00000000 00010007 00000000 0090008E 65153AFC 664DD574
06/06/2008 08:45:56,spid187,Unknown,* Ebx: FFFFFFFF:
06/06/2008 08:45:56,spid187,Unknown,* Eax: 664DD544: 000042AC 00000000 00000000 77E4BEE7 00000000 7C82771B
06/06/2008 08:45:56,spid187,Unknown,* Esi: 00000000:
06/06/2008 08:45:56,spid187,Unknown,* Edi: 664DD660: 65153AF8 664DD684 01006176 664DD684 0100617E 027E5570
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* dbghelp 66BE0000 66CF4FFF 00115000
06/06/2008 08:45:56,spid187,Unknown,* OLEDB32R 63D60000 63D70FFF 00011000
06/06/2008 08:45:56,spid187,Unknown,* MSDART 63C10000 63C29FFF 0001a000
06/06/2008 08:45:56,spid187,Unknown,* oledb32 64090000 64108FFF 00079000
06/06/2008 08:45:56,spid187,Unknown,* xplog70 64730000 64732FFF 00003000
06/06/2008 08:45:56,spid187,Unknown,* xplog70 64710000 6471BFFF 0000c000
06/06/2008 08:45:56,spid187,Unknown,* xpstar90 645E0000 64605FFF 00026000
06/06/2008 08:45:56,spid187,Unknown,* odbcint 645C0000 645D6FFF 00017000
06/06/2008 08:45:56,spid187,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/06/2008 08:45:56,spid187,Unknown,* BatchParser90 643D0000 643EEFFF 0001f000
06/06/2008 08:45:56,spid187,Unknown,* ODBC32 64390000 643CCFFF 0003d000
06/06/2008 08:45:56,spid187,Unknown,* SQLSCM90 64370000 64378FFF 00009000
06/06/2008 08:45:56,spid187,Unknown,* xpstar90 64310000 64358FFF 00049000
06/06/2008 08:45:56,spid187,Unknown,* xpsqlbot 642F0000 642F5FFF 00006000
06/06/2008 08:45:56,spid187,Unknown,* msftepxy 637C0000 637D4FFF 00015000
06/06/2008 08:45:56,spid187,Unknown,* SQLNCLIR 007C0000 007F2FFF 00033000
06/06/2008 08:45:56,spid187,Unknown,* comdlg32 762B0000 762F8FFF 00049000
06/06/2008 08:45:56,spid187,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/06/2008 08:45:56,spid187,Unknown,* sqlncli 63410000 63633FFF 00224000
06/06/2008 08:45:56,spid187,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/06/2008 08:45:56,spid187,Unknown,* xpsp2res 63140000 63404FFF 002c5000
06/06/2008 08:45:56,spid187,Unknown,* ntdsapi 766F0000 76703FFF 00014000
06/06/2008 08:45:56,spid187,Unknown,* SAMLIB 7E020000 7E02EFFF 0000f000
06/06/2008 08:45:56,spid187,Unknown,* NTMARTA 77E00000 77E20FFF 00021000
06/06/2008 08:45:56,spid187,Unknown,* wshtcpip 71AE0000 71AE7FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* hnetcfg 62FA0000 62FF9FFF 0005a000
06/06/2008 08:45:56,spid187,Unknown,* dssenh 68100000 68126FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* imagehlp 76C10000 76C37FFF 00028000
06/06/2008 08:45:56,spid187,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/06/2008 08:45:56,spid187,Unknown,* dbghelp 62BB0000 62CC4FFF 00115000
06/06/2008 08:45:56,spid187,Unknown,* msfte 62950000 62BA8FFF 00259000
06/06/2008 08:45:56,spid187,Unknown,* security 62280000 62283FFF 00004000
06/06/2008 08:45:56,spid187,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
06/06/2008 08:45:56,spid187,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/06/2008 08:45:56,spid187,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/06/2008 08:45:56,spid187,Unknown,* DNSAPI 76ED0000 76EF9FFF 0002a000
06/06/2008 08:45:56,spid187,Unknown,* RESUTILS 61E30000 61E42FFF 00013000
06/06/2008 08:45:56,spid187,Unknown,* CLUSAPI 61E10000 61E21FFF 00012000
06/06/2008 08:45:56,spid187,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/06/2008 08:45:56,spid187,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* MTXCLU 61DF0000 61E08FFF 00019000
06/06/2008 08:45:56,spid187,Unknown,* msvcp60 61D80000 61DE4FFF 00065000
06/06/2008 08:45:56,spid187,Unknown,* OLEAUT32 77D00000 77D8AFFF 0008b000
06/06/2008 08:45:56,spid187,Unknown,* MSDTCPRX 61D00000 61D78FFF 00079000
06/06/2008 08:45:56,spid187,Unknown,* XOLEHLP 61CF0000 61CF5FFF 00006000
06/06/2008 08:45:56,spid187,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/06/2008 08:45:56,spid187,Unknown,* schannel 76750000 76776FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/06/2008 08:45:56,spid187,Unknown,* kerberos 61C40000 61C97FFF 00058000
06/06/2008 08:45:56,spid187,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/06/2008 08:45:56,spid187,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/06/2008 08:45:56,spid187,Unknown,* ole32 77670000 777A8FFF 00139000
06/06/2008 08:45:56,spid187,Unknown,* MSCOREE 34200000 34245FFF 00046000
06/06/2008 08:45:56,spid187,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/06/2008 08:45:56,spid187,Unknown,* rsaenh 68000000 68034FFF 00035000
06/06/2008 08:45:56,spid187,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/06/2008 08:45:56,spid187,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/06/2008 08:45:56,spid187,Unknown,* instapi 48060000 48069FFF 0000a000
06/06/2008 08:45:56,spid187,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/06/2008 08:45:56,spid187,Unknown,* comctl32 77420000 77522FFF 00103000
06/06/2008 08:45:56,spid187,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/06/2008 08:45:56,spid187,Unknown,* SHELL32 7C8D0000 7D0CEFFF 007ff000
06/06/2008 08:45:56,spid187,Unknown,* NETAPI32 71C40000 71C96FFF 00057000
06/06/2008 08:45:56,spid187,Unknown,* opends60 333E0000 333E6FFF 00007000
06/06/2008 08:45:56,spid187,Unknown,* USERENV 76920000 769E1FFF 000c2000
06/06/2008 08:45:56,spid187,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/06/2008 08:45:56,spid187,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/06/2008 08:45:56,spid187,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/06/2008 08:45:56,spid187,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/06/2008 08:45:56,spid187,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/06/2008 08:45:56,spid187,Unknown,* GDI32 77C00000 77C47FFF 00048000
06/06/2008 08:45:56,spid187,Unknown,* USER32 77380000 77410FFF 00091000
06/06/2008 08:45:56,spid187,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/06/2008 08:45:56,spid187,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/06/2008 08:45:56,spid187,Unknown,* ADVAPI32 77F50000 77FEAFFF 0009b000
06/06/2008 08:45:56,spid187,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/06/2008 08:45:56,spid187,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/06/2008 08:45:56,spid187,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/06/2008 08:45:56,spid187,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/06/2008 08:45:56,spid187,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/06/2008 08:45:56,spid187,Unknown,* sqlservr 01000000 02C09FFF 01c0a000
06/06/2008 08:45:56,spid187,Unknown,* MODULE BASE END SIZE
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* 04 04 00 00 00 00
06/06/2008 08:45:56,spid187,Unknown,* h r e s h o l d & 68 00 72 00 65 00 73 00 68 00 6f 00 6c 00 64 00 00 26
06/06/2008 08:45:56,spid187,Unknown,* T h r o t t l e T 54 00 68 00 72 00 6f 00 74 00 74 00 6c 00 65 00 54 00
06/06/2008 08:45:56,spid187,Unknown,* i z e & d @ 00 69 00 7a 00 65 00 00 26 04 04 64 00 00 00 12 40 00
06/06/2008 08:45:56,spid187,Unknown,* M a x F e t c h S 00 4d 00 61 00 78 00 46 00 65 00 74 00 63 00 68 00 53
06/06/2008 08:45:56,spid187,Unknown,* I d ç ÿÿ @ 00 49 00 64 00 00 e7 02 00 09 04 10 00 00 ff ff 0d 40
06/06/2008 08:45:56,spid187,Unknown,* É µ @ B a t c h 00 a0 c9 0a b5 0f 08 40 00 42 00 61 00 74 00 63 00 68
06/06/2008 08:45:56,spid187,Unknown,* p e $ ßê½eÂ� ¼í 70 00 65 00 00 24 10 10 17 df ea bd 65 c2 d0 11 bc ed
06/06/2008 08:45:56,spid187,Unknown,* o r k I t e m T y 6f 00 72 00 6b 00 49 00 74 00 65 00 6d 00 54 00 79 00
06/06/2008 08:45:56,spid187,Unknown,* d ç ÿÿ @ W 64 00 00 e7 02 00 09 04 10 00 00 ff ff 0d 40 00 57 00
06/06/2008 08:45:56,spid187,Unknown,* å ô« @ S i t e I e5 80 f4 ab 15 07 40 00 53 00 69 00 74 00 65 00 49 00
06/06/2008 08:45:56,spid187,Unknown,* d $ & Ǿ´Ó>Kµ�X 00 64 00 00 24 10 10 26 06 c7 be b4 d3 3e 4b b5 cd 58
06/06/2008 08:45:56,spid187,Unknown,* o c e s s i n g I 00 6f 00 63 00 65 00 73 00 73 00 69 00 6e 00 67 00 49
06/06/2008 08:45:56,spid187,Unknown,* I t e m s @ P r 49 00 74 00 65 00 6d 00 73 00 00 00 0d 40 00 50 00 72
06/06/2008 08:45:56,spid187,Unknown,* n a b l e W o r k 6e 00 61 00 62 00 6c 00 65 00 57 00 6f 00 72 00 6b 00
06/06/2008 08:45:56,spid187,Unknown,* o c _ G e t R u n 6f 00 63 00 5f 00 47 00 65 00 74 00 52 00 75 00 6e 00
06/06/2008 08:45:56,spid187,Unknown,* d b o . p r 01 00 00 00 1d 00 64 00 62 00 6f 00 2e 00 70 00 72 00
06/06/2008 08:45:56,spid187,Unknown,* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
06/06/2008 08:45:56,spid187,Unknown,* Input Buffer 255 bytes -
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* ex_raise2: Exception raised<c/> major=2<c/> minor=11<c/> state=51<c/> severity=23
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* 06/06/08 08:45:56 spid 187
06/06/2008 08:45:56,spid187,Unknown,* BEGIN STACK DUMP:
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* *******************************************************************************
06/06/2008 08:45:56,spid187,Unknown,***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump9210.txt
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,* User initiated stack dump. This is not a server exception dump.
06/06/2008 08:45:56,spid187,Unknown,*
06/06/2008 08:45:56,spid187,Unknown,**Dump thread - spid = 187<c/> PSS = 0x0B74D5C0<c/> EC = 0x0B74D5C8
06/06/2008 08:45:56,spid187,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/06/2008 08:45:56,spid187,Unknown,ex_raise2: Exception raised<c/> major=2<c/> minor=11<c/> state=51<c/> severity=23<c/> attempting to create symptom dump

Any help would be greatly appreciated

View 3 Replies


ADVERTISEMENT

DBCC Execution Completed. If DBCC Printed Error Messages, Contact Your System Adminis

Mar 26, 2007

Hi All,

I am playing with DBCC command to check the contsrainst on a perticular table (DBCC CHECKCONSTRAINTS ('myTable') WITH ALL_CONSTRAINTS), it always gives the following result:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

nothing more than that, anyone can help please?

Cheers,
Riaz

View 3 Replies View Related

How DBCC CHECKDB And DBCC CHECKCATALOG After Executing These Two Then Store Result

Mar 5, 2005

For Backup Database i used script
BACKUP DATABSE.

Then after that, i need to check Database inigrity, for that
i used DBCC CHECKDB and DBCC CHECKCATALOG

but, i want to store the result in a text file, after executing these two commends, how to write commend line please help me.

View 1 Replies View Related

DBCC Shrinkfile/database

May 14, 2001

Hi,
Are there any effects(negative) of running dbcc shrinkdatabase/file on a production box at low/high usage time or high/low activity period of db?
TIA

View 1 Replies View Related

Dbcc Shrink Database

Nov 4, 2004

Morning,

Is there a specific command/clause in the DBCC SHRINKDATABASE command where I can force a database to release free space to the operating system ?

Cheers,

Duncan

View 3 Replies View Related

DBCC ERROR ON CHECKING THE DATABASE

Feb 23, 1999

Hi all,
We have been checking the database by dbcc checkdb,through a automated task
on our production server (nightly task run everday)d we always getting the message given below.

Msg 625, Level 20, state 1
Could not retrieve row from logical page 957298 via RID because the entry in the offset table (=0) for that RID (=17) is less than or equal to 0.

If anyone knows about this error message, can you kindly post the message.

Thanks a lot.

Jay.

View 1 Replies View Related

Database DBCC CHECKDB Errors

Jan 30, 2007

Hi all

I have a database that is being restored to another instance of SQL server 2000 sp4 by attatching the mdf and ldf files. I then run EXEC sp_change_users_login to sync the users. When I try to run some delete commands on the new restored database I get 'Fatal error 8908'

I then run a DBCC CHECKDB on the database and told to run it again with REPAIR_ALLOW_DATA_LOSS

I have noticed that when I create a new databse and restore a .bak over this the delete commands work.

Am I correct in thinking that I can get rid of the corruption on the original database by creating a new database then restoring a valid .bak backup on this new database.

View 3 Replies View Related

Database Problem Dbcc Checkdb

Oct 17, 2007

I've read the bad news in other post but hopefully I misunderstood them. We have a database on an old sql 2000 server which had a data drive failure. The last backup is a year old. They told me they stopped doing backups because nothing was going to change. Well, changes were made to structures and stored procedures on the production (only) server and they want to try to recover the database. Should I bother opening a support call with MS? I'm embarred to even post the question but you never know. The database is currently in emergency mode. I can't see any of the user tables or stored procedures in Mangement Studio.

Msg 8966, Level 16, State 1, Line 1

Could not read and latch page (1:17913) with latch type SH. sysobjects failed.

View 5 Replies View Related

DBCC Page / DBCC Checkdb Errors

Jan 9, 2007

Following the below topic:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271

I followed the advice of Paul Randal, but Im stumped as I am not able to determin what the corruption issues are. This is SQL 2000 and the database is a Solomon database that was recently upgraded to 6.5. the error I get when running the DBCC checkdb is as follows:

Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:18645) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

When I run select * from sysindexes, I get:

Server: Msg 3624, Level 20, State 1, Line 1

Location: blobman.cpp:1780
Expression: sourceLength == sizeof (TextPointer)
SPID: 53
Process ID: 256

Connection Broken

When I run dbcc page (dbname, 1, 18645, 3)
dbcc traceon(3604), It finishes with what appears to be no errors log is as follows:


PAGE: (1:18645)
---------------

BUFFER:
-------

BUF @0x0144C880
---------------
bpage = 0x681B4000 bhash = 0x00000000 bpageno = (1:18645)
bdbid = 12 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x681B4000
----------------
m_pageId = (1:18645) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:505)
m_nextPage = (1:213) pminlen = 82 m_slotCnt = 16
m_freeCnt = 3988 m_freeData = 5796 m_reservedCnt = 0
m_lsn = (42700:4549:10) m_xactReserved = 0 m_xdesId = (0:2539719)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:16176) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED

Slot 0 Offset 0xf8c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4F8C: 00520030 013f142a 00004012 00000000 0.R.*.?..@......
681B4F9C: 00010000 00000000 02600000 00010001 ..........`.....
681B4FAC: 00000000 00000000 00000000 00000000 ................
681B4FBC: 00000000 00000000 027a0000 00000022 ..........z."...
681B4FCC: 00000000 00000000 00000000 00000000 ................
681B4FDC: 001b0000 00000000 00800003 80a60096 ................
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
681B500C: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B501C: 00680063 00000030 002a869d 00570000 c.h.0.....*...W.
681B502C: 00010000 0007 ......
id = 20911146
status = 16402
first = 0
indid = 1
root = 0
minlen = 608
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 634
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
name = smInvBatch0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647062528 RowId = (1:87:7)

Slot 1 Offset 0x12c4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B52C4: 00520030 013f142a 00000000 00000000 0.R.*.?.........
681B52D4: 00020000 00000000 00150000 00010003 ................
681B52E4: 00000000 00000000 00000000 00000000 ................
681B52F4: 00000000 00000000 00260000 0000002c ..........&.,...
681B5304: 00000000 00000000 00000000 00000000 ................
681B5314: 001b0000 00000000 00c00003 80e600d6 ................
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
681B5384: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B5394: 00680063 00000031 002a869f 00570000 c.h.1.....*...W.
681B53A4: 00010000 0008 ......
id = 20911146
status = 0
first = 0
indid = 2
root = 0
minlen = 21
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 38
maxirow = 44
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
name = smInvBatch1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647193600 RowId = (1:87:8)

Slot 2 Offset 0x1440
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B5440: 00520030 01584911 00004012 000000c6 0.R..IX..@......
681B5450: 00010001 00000095 09a20001 00010001 ................
681B5460: 00000001 00000005 00000005 00000000 ................
681B5470: 00000000 00000003 09ba0000 0000001a ................
681B5480: 00000000 00000096 00000001 00000000 ................
681B5490: 001b0000 00000000 00800003 80a60096 ................
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
681B54C0: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B54D0: 0065006d 00000030 002a87a9 03a00000 m.e.0.....*.....
681B54E0: 00010000 0019 ......
id = 22563089
status = 16402
first = 0
indid = 1
root = 0
minlen = 2466
keycnt = 1
groupid = 1
dpages = 1
reserved = 5
used = 5
rowcnt = 0
rowmodctr = 3
reserved3 = 0
reserved4 = 0
xmaxlen = 2490
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
name = RptRuntime0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664626176 RowId = (1:928:25)

Slot 3 Offset 0x15bc
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B55BC: 00520030 01584911 00000000 000000e6 0.R..IX.........
681B55CC: 00020001 000000e6 00470001 00010003 ..........G.....
681B55DC: 00000001 00000002 00000002 00000000 ................
681B55EC: 00000000 00000000 00580000 0000005e ..........X.^...
681B55FC: 00000000 00000161 00000001 00000000 ....a...........
681B560C: 001b0000 00000000 00c00003 80e600d6 ................
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
681B567C: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B568C: 0065006d 00000031 002a87ab 3eb70000 m.e.1.....*....>
681B569C: 00010000 0004 ......
id = 22563089
status = 0
first = 0
indid = 2
root = 0
minlen = 71
keycnt = 3
groupid = 1
dpages = 1
reserved = 2
used = 2
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 88
maxirow = 94
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
name = RptRuntime1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664757248 RowId = (1:16055:4)

Slot 4 Offset 0xc04
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4C04: 00520030 0175b502 00004012 00000000 0.R...u..@......
681B4C14: 00010000 00000000 040c0000 00010001 ................
681B4C24: 00000000 00000000 00000000 00000000 ................
681B4C34: 00000000 00000000 04270000 00000022 ..........'."...
681B4C44: 00000000 00000000 00000000 00000000 ................
681B4C54: 001b0000 00000000 00800003 80a60096 ................
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
681B4C84: 006f0057 006b0072 00650043 0074006e W.o.r.k.C.e.n.t.
681B4C94: 00720065 00000030 002a84b7 55880000 e.r.0.....*....U
681B4CA4: 00010000 0007 ......
id = 24491266
status = 16402
first = 0
indid = 1
root = 0
minlen = 1036
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1063
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
name = WorkCenter0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182615212032 RowId = (1:21896:7)

Slot 5 Offset 0xb64
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4B64: 00520030 01ab548a 00004012 00000000 0.R..T...@......
681B4B74: 00010000 00000000 038e0000 00010001 ................
681B4B84: 00000000 00000000 00000000 00000000 ................
681B4B94: 00000000 00000000 03b00000 0000001a ................
681B4BA4: 00000000 00000000 00000000 00000000 ................
681B4BB4: 001b0000 00000000 00800003 80a00090 ................
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
681B4BE4: 004f0053 00650053 00750074 00300070 S.O.S.e.t.u.p.0.
681B4BF4: 84010000 0000002a 00000f23 00070001 ....*...#.......
id = 28005514
status = 16402
first = 0
indid = 1
root = 0
minlen = 910
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 944
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
name = SOSetup0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182603284480 RowId = (1:3875:7)

Slot 6 Offset 0x58c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B458C: 00520030 01c4f563 00004012 00000000 0.R.c....@......
681B459C: 00010000 00000000 04c70000 00010002 ................
681B45AC: 00000000 00000000 00000000 00000000 ................
681B45BC: 00000000 00000000 04e80000 00000027 ............'...
681B45CC: 00000000 00000000 00000000 00000000 ................
681B45DC: 001b0000 00000000 00a00003 80c400b4 ................
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
681B462C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B463C: 00300074 82fd0000 0000002a 0000068a t.0.....*.......
681B464C: 00490001 ..I.
id = 29685091
status = 16402
first = 0
indid = 1
root = 0
minlen = 1223
keycnt = 2
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1256
maxirow = 39
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
name = PurOrdDet0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586245120 RowId = (1:1674:73)

Slot 7 Offset 0x650
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4650: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4660: 00020000 00000000 002e0000 00010003 ................
681B4670: 00000000 00000000 00000000 00000000 ................
681B4680: 00000000 00000000 003f0000 00000045 ..........?.E...
681B4690: 00000000 00000000 00000000 00000000 ................
681B46A0: 001b0000 00000000 00c00003 80e400d4 ................
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
681B4710: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4720: 00310074 83040000 0000002a 0000068a t.1.....*.......
681B4730: 004a0001 ..J.
id = 29685091
status = 0
first = 0
indid = 2
root = 0
minlen = 46
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 63
maxirow = 69
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
name = PurOrdDet1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586703872 RowId = (1:1674:74)

Slot 8 Offset 0x734
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4734: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4744: 00030000 00000000 00340000 00010004 ..........4.....
681B4754: 00000000 00000000 00000000 00000000 ................
681B4764: 00000000 00000000 00450000 0000004b ..........E.K...
681B4774: 00000000 00000000 00000000 00000000 ................
681B4784: 001b0000 00000000 00e00003 810400f4 ................
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
681B4814: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4824: 00320074 83050000 0000002a 0000068a t.2.....*.......
681B4834: 004b0001 ..K.
id = 29685091
status = 0
first = 0
indid = 3
root = 0
minlen = 52
keycnt = 4
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 69
maxirow = 75
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
name = PurOrdDet2

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586769408 RowId = (1:1674:75)

Slot 9 Offset 0x838
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4838: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4848: 00040000 00000000 00120000 00010005 ................
681B4858: 00000000 00000000 00000000 00000000 ................
681B4868: 00000000 00000000 00230000 00000029 ..........#.)...
681B4878: 00000000 00000000 00000000 00000000 ................
681B4888: 001b0000 00000000 01000003 81240114 ..............$.
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
681B4938: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4948: 00330074 83060000 0000002a 0000068a t.3.....*.......
681B4958: 004c0001 ..L.
id = 29685091
status = 0
first = 0
indid = 4
root = 0
minlen = 18
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 35
maxirow = 41
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
name = PurOrdDet3

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586834944 RowId = (1:1674:76)

Slot 10 Offset 0x95c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B495C: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B496C: 00050000 00000000 003a0000 00010005 ..........:.....
681B497C: 00000000 00000000 00000000 00000000 ................
681B498C: 00000000 00000000 004b0000 00000051 ..........K.Q...
681B499C: 00000000 00000000 00000000 00000000 ................
681B49AC: 001b0000 00000000 01000003 81240114 ..............$.
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
681B4A5C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4A6C: 00340074 83070000 0000002a 0000068a t.4.....*.......
681B4A7C: 004d0001 ..M.
id = 29685091
status = 0
first = 0
indid = 5
root = 0
minlen = 58
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 75
maxirow = 81
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
name = PurOrdDet4

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586900480 RowId = (1:1674:77)

Slot 11 Offset 0xa80
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4A80: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4A90: 00060000 00000000 00200000 00010003 .......... .....
681B4AA0: 00000000 00000000 00000000 00000000 ................
681B4AB0: 00000000 00000000 00310000 00000037 ..........1.7...
681B4AC0: 00000000 00000000 00000000 00000000 ................
681B4AD0: 001b0000 00000000 00c00003 80e400d4 ................
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
681B4B40: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4B50: 00350074 83080000 0000002a 0000068a t.5.....*.......
681B4B60: 004e0001 ..N.
id = 29685091
status = 0
first = 0
indid = 6
root = 0
minlen = 32
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 49
maxirow = 55
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
name = PurOrdDet5

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586966016 RowId = (1:1674:78)

Slot 12 Offset 0xcac
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4CAC: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4CBC: 00070000 00000000 00110000 00010003 ................
681B4CCC: 00000000 00000000 00000000 00000000 ................
681B4CDC: 00000000 00000000 00220000 00000028 ..........".(...
681B4CEC: 00000000 00000000 00000000 00000000 ................
681B4CFC: 001b0000 00000000 00c00003 80ee00de ................
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
681B4D6C: 00750070 006f0072 00640072 00650064 p.u.r.o.r.d.d.e.
681B4D7C: 005f0074 00740073 00610072 0000006e t._.s.t.r.a.n...
681B4D8C: 002a84c7 78450000 00010000 001d ..*...Ex......
id = 29685091
status = 0
first = 0
indid = 7
root = 0
minlen = 17
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 34
maxirow = 40
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
name = purorddet_stran

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182616260608 RowId = (1:30789:29)

Slot 13 Offset 0xd4
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B40D4: 00520030 01d345b0 00004012 00000000 0.R..E...@......
681B40E4: 00010000 00000000 019b0000 00010006 ................
681B40F4: 00000000 00000000 00000000 00000000 ................
681B4104: 00000000 00000000 01b00000 0000007b ............{...
681B4114: 00000000 00000000 00000000 00000000 ................
681B4124: 001b0000 00000000 01200003 81460136 .......... .6.F.
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
681B41F4: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4204: 006c0063 00000030 002a8221 4d150000 c.l.0...!.*....M
681B4214: 00010000 003f ....?.
id = 30623152
status = 16402
first = 0
indid = 1
root = 0
minlen = 411
keycnt = 6
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 432
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
name = OptDepExcl0

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182571827200 RowId = (1:19733:63)

Slot 14 Offset 0x21c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B421C: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B422C: 00020000 00000000 00640000 00010008 ..........d.....
681B423C: 00000000 00000000 00000000 00000000 ................
681B424C: 00000000 00000000 00750000 0000007b ..........u.{...
681B425C: 00000000 00000000 00000000 00000000 ................
681B426C: 001b0000 00000000 01600003 81860176 ..........`.v...
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
681B437C: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B438C: 006c0063 00000031 002a8224 4d150000 c.l.1...$.*....M
681B439C: 00010000 0040 ....@.
id = 30623152
status = 0
first = 0
indid = 2
root = 0
minlen = 100
keycnt = 8
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 117
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
name = OptDepExcl1

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572023808 RowId = (1:19733:64)

Slot 15 Offset 0x3a4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B43A4: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B43B4: 00030000 00000000 00660000 0001000b ..........f.....
681B43C4: 00000000 00000000 00000000 00000000 ................
681B43D4: 00000000 00000000 00770000 0000007d ..........w.}...
681B43E4: 00000000 00000000 00000000 00000000 ................
681B43F4: 001b0000 00000000 01c00003 81e601d6 ................
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
681B4564: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4574: 006c0063 00000032 002a8225 4d150000 c.l.2...%.*....M
681B4584: 00010000 0041 ....A.
id = 30623152
status = 0
first = 0
indid = 3
root = 0
minlen = 102
keycnt = 11
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 119
maxirow = 125
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0

keys
--------------------------------
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
name = OptDepExcl2

statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572089344 RowId = (1:19733:65)

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Now, the bad news. I am a bit of a novice and have picked this up from someone who left my company. It appears the latch error has been around for some time and only reared up when I instituted a new back up system that runs a dbcc check befor backing up. I don't think I have any clean backups.

Any help would be greatly appreciated.

Alex Mauer

View 17 Replies View Related

DBCC CHECKDB And Database Maintenance Plans

Dec 14, 2000

According to the books online:

In earlier versions of SQL Server, it was recommended that DBCC statements be made a regular part of a database backup strategy.
It was recommended that databases be checked before being backed up. In SQL Server 7.0, this is no longer necessary.

Are integrity checks really no longer necessary in SQL Server 7? I have a third-party book in which the author states that he still does them
anyway. Should I continue to do DBCC CHECKDB?

Also, I am using database maintenance plans for several SQL Servers. When the integrity checks are performed will it log any errors
in the output log generated during the execution of the maintenance plan? The logs I receive look like the following:

[2] Database CPMCC_GL: Check Data and Index Linkage...

** Execution Time: 0 hrs, 39 mins, 54 secs **

If an error is detected would it be recorded here, or is this just a log to let me know that the checks were performed?

Tony

View 1 Replies View Related

Should I Proceed With Upgrade To 7.0 When DBCC Fail On V6.5 Database?

Mar 6, 1999

Hi,
I am preparing to upgrade my database to 7.0. While doing DBCC on my existing database (in version 6.5), the process completed with status fail.
Below is the message given:

Processed 64 entries in the Sysindexes for dbid 7.
Found 7 bad entries in the Sysindexes.
DBCC execution completed. If DBCC printed error messages, see your System Administrator.

Should I just ignore this message and proceed? If I were to clean up the bad entries, how do I proceed?

I appreciate very much for all suggestions.

Regards,
Joo Pheng

View 1 Replies View Related

Get Corrupt Database With Dbcc Checkdb Or Newalloc

Jul 8, 1999

Hi

Our supplyer of application we use say that dbcc checkdb or dbcc newalloc can
give corrupt database (use version 6.5). I wonders about this statement. Are ther some how have explanation about this

Kent vahlen

View 2 Replies View Related

DBCC CHECKDB Won't Run On Corrupted Database SQL2K

Mar 29, 2007

Let me start off by saying that under normal circumstance I would just restore from the last good backup. However in this case it appears as though the last good backup was sometime last August ... arg! After much yelling at the person responsible I've been attempting to get my blood pressure below 200 and see what data is recoverable.

First off, this was a RAID5 system that failed 1 drive. Secondly, before we got someone in there to replace said drive it failed a second drive and the system went down. We managed to massage the system back online but it appears that there is some corruption as a result which is no surprise.

I've done DB repairs in the past and it hasn't been too bad, but this time it is looking a little gnarly.

I've kicked everyone off the server and tried starting SQLServer several different ways.

I tried starting the service normally and then flagging the bad DB into single user mode with "ALTER DATABASE foo SET SINGLE_USER". I then did a select * from sysdatabases to make sure it took, which it did. I also tried starting the whole SQLServer in single user mode from the command line, "SQLServr -m".

I can run "DBCC CHECKDB('foo')" and I get a long ugly list of allocation errors. I posted it to a link as the 1349 lines returned is a little long:
http://chrisnet.net/sqlbad/dbcc_checkdb.txt

But when I attempt to bite the bullet and destroy data in an attempt to put things back together with:
"DBCC CHECKDB('foo', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS"
I get:
Server: Msg 7919, Level 16, State 2, Line 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

But yet the database is in single user mode, according to everything I check check on. Is this just SQL's way of telling me the corruption is too severe to be repaired? No output is displayed in the shell cmd window like it is for a successful DBCC either (when running sqlservr -m).

Ideas? Or do I put a bullet through it's brain?

-Chris

View 7 Replies View Related

DBCC CHECKDB Is Failing On The Msdb Database

Jul 26, 2007

When I try to delete a job from Enterprise Manager Console I get the following error:
Erro 644: Could not find the index entry for RID '163bd10000010000' in index page (1:553), index ID 0 database 'msdb'

Oh and this is on MSDE.

Here is my complete output of DBCC CHECKDB
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 280 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 143 rows in 6 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1567 rows in 26 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 357 rows in 108 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 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 1635 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 12 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 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 'backupset'.
There are 1045 rows in 44 pages for object 'backupset'.
DBCC results for 'sysjobschedules'.
There are 7 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'backupfile'.
There are 1451 rows in 24 pages for object 'backupfile'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'restorehistory'.
There are 1 rows in 1 pages for object 'restorehistory'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'restorefile'.
There are 2 rows in 1 pages for object 'restorefile'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 0 rows in 0 pages for object 'syscachedcredentials'.
DBCC results for 'restorefilegroup'.
There are 1 rows in 1 pages for object 'restorefilegroup'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object 'sysdtspackages'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'sysdtssteplog'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:343) on page (1:371) does not match the previous page (1:382) that the parent (1:300), slot 32 expects for this page.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Page (1:371) is missing a reference from previous page (1:343). Possible chain linkage problem.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'sysdbmaintplans'.
There are 4 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 4 rows in 1 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'sysdbmaintplan_databases'.
There are 12 rows in 1 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'sysdbmaintplan_history'.
There are 724 rows in 23 pages for object 'sysdbmaintplan_history'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediaset'.
There are 1045 rows in 11 pages for object 'backupmediaset'.
DBCC results for 'sysjobhistory'.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:382) on page (1:564) does not match the previous page (1:371) that the parent (1:300), slot 33 expects for this page.
There are 626 rows in 208 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 7 rows in 1 pages for object 'sysjobs'.
DBCC results for 'backupmediafamily'.
There are 1045 rows in 20 pages for object 'backupmediafamily'.
DBCC results for 'sysjobservers'.
There are 7 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'sysjobsteps'.
There are 9 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 3 consistency errors in database 'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

View 1 Replies View Related

SQL Server 2008 :: Run DBCC CHECKDB Using Snapshot Of The Database

Dec 8, 2014

I have huge database on prod. One time I tried to run DBCC CHECKDB, it took more than a day. My question is can I created a snapshot of the prod database on the same server and run DBCC CHECKDB on the Snapshot DB? will doing this interfere production database? I don’t have option to make copy of the database on a test server and run it there.

View 9 Replies View Related

Database Fails Dbcc Check Db With Multiple Errors

May 1, 2014

I am not a DBA but have responsibility for a particular MSSQL 2008 R2 file server running a particular application.how to solve a database consistency check problem.The database fails dbcc checkdb with multiple 8903 errors. Unfortunately this was not discovered until well after any good backups were deleted. The good news is that the DB otherwise seems fine. We have experienced zero problems with the DB or the applications. Running the checkdb with the "repair_allow_data_loss" option does not fix the problem.

However, I would still like to fix the problem. Using a popular SQL recovery product I am able to recover the database.The original, vendor designed and supplied DB, has 2 file groups, and three files (MDF, NDF, LDF). The output of the recovery process produces 1 file group and 2 files (MDF and LDF). Vendor says they cannot support me since the recovered DB is 'non-standard' according to their design.

I am able to set up a new, blank version of the vendors database on another dev system with the proper file and filegroup structure. How can I get the data moved/copied from the recovered (MDF/LDF) database into the dev database (MDF, NDF, LDF). I've tried the import/export function but it fails (I can rerun and give details if necessary).

View 1 Replies View Related

Suspect Database - DBCC CHECKDB Throws Error

Apr 13, 2007

Hi all,

we've been having this ancient database with old accounting data running in suspect mode since as long as I can remember (I started working here a year ago), and finally I had some time on my hands so I thought I'd try to get it online again. However I'm running in to problems:

DBCC CHECKDB (myDBName) gives this error:
Msg 926, Level 14, State 1, Line 1
Database 'myDBName' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Running sp_helpdb only does not display the suspect database and sp_helpdb 'myDBName' gives this error even though I'm a system administrator:
No permission to access database 'myDBName'.

It's possible that I might be able to dig up a backup but that would be quite tedious. Is it possible to bring the database to a state where I'm able to do a CHECKDB at least...?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

View 5 Replies View Related

DBCC Srhinkfile Didn&#39;t Shrink The File But Expand The Database Instead!!

Apr 6, 2001

I have a 2.8G SQL 7 database with 1.6G used space. I want to shrink it to 1.8G, but after I issued the 'DBCC srhinkfile(datafile, 1800)', it didn't shrink the file, instead it expanded to 2.7G used space? I tried on a test server, the command worked every time although the time to complete the task tended to increase every time.

I did the DBCC DBREINDEX (fill factor 90) and updated usage, the size didn't change. DBCC CHECKDB, CATELOG AND SHOWCONTIG were all performed and there wasn't any error or fragmentation.

Now I'm wondering what's the actual size of my database, 1.6G or 2.7G? If there's a way that I can get back close to my original used sized, then I can try to shink the file again. Any comment is welcome. Thanks advance.

View 4 Replies View Related

Applying DBCC DBREINDEX On A Database That Is Part Of Transaction Replication

Mar 4, 2007

I am about to apply DBCC DBREINDEX to a large database that is part of transactional replication and synchronised every 3 minutes. What are the likely implication and what precautions I must take.





Thanks in advance

Regards

R Suresh

View 1 Replies View Related

SQL Tools :: DBCC CHECKDB Error / Internal Database Snapshot Cannot Be Created

Aug 22, 2013

We recently migrated our production server from SQL 2005 (Standard) on Win2003(32-bit) to SQL2012 (Standard; v11.0.3000) on Win2008-R2(64bit). Single-server Dell R510 with 1.2TB storage. Everything went smoothly; the only nagging issue remaining is failure of our maintenance jobs. I tracked the issue down to failure of DBCC CHECKDB.  Specifically, the error is:Executed as user: NT SERVICESQLSERVERAGENT. The database could not be exclusively locked to perform the operation. [SQLSTATE 42000] (Error 5030) Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be lockedI have Googled this issue and read extensively. For instance, informative blogs (albeit dated) such as these by Paul Randal (Managing

CheckDB by default takes an internal DB snapshot to get the consistent, point-in-time view of the DB that it needs. If that snapshot creation fails, then it will try to get an exclusive database lock before proceeding (same as if you had executed DBCC CHECKDB WITH TABLOCK). The root problem is not that the lock could not be obtained, it's that the internal database snapshot could not be created. msdn.microsoft.com/en-us/library/ms188796.aspx details the specific situations when an internal database snapshot is not created and table locking is attempted. 

 I have verified the SQLSERVERAGENT service account has full permissions on the SQLDATA directory where the databases reside and has full permissions on each database within the directory. Just for giggles, I created a job (run as SQLSERVERAGENT) that creates and then deletes a text file in the SQLDATA directory.  It runs fine.

Also testedI get the snapshot creation error when manually running DBCC CHECKDB against any of our databases and when executing under a variety of administrator accounts that are members of the SQL sysadmin role and the Domain Admins security group (the Domain Admins is a member of the local Administrators group that has full permissions on all SQL directories/folders).

Additionally, the databases in question are small (200MB to 6GB) and the disk has plenty of elbow room (978GB free on 1.22TB RAID5 array) to create the internal database snapshots. CHECKDB doesn't surface an error message that is detailed enough to determine the precise cause of the error. Any example successfully running DBCC CHECKDB on the SQL2012 (Standard) on a Win2008 R2 (64-bit) server.

View 22 Replies View Related

DBCC DEFRAG Vs DBCC DBREINDEX

May 11, 2006

What factors would make you decide to use DBCC DBREINDES instead of DBCC DEFRAG when you notice index defragmantation?

Thanks.

ekareem

View 1 Replies View Related

TempDB Log File Running Out Of Free Space While Running DBCC CheckDB On Large Database

May 28, 2015

In my environment, there is maintenance plan configured on one of the server and while running DBCC checkdb on a database of size around 200GB, log file usage of tempdb is increasing and causing the maintenance job to fail.

What can I do to make the maintenance job run successfully, size of the tempdb database is only 50GB and recovery model is set to simple. It cannot be increased as the mount point on which it is residing is 50GB.

View 3 Replies View Related

DBCC When Should I Use It

Oct 30, 2000

hi, is there a sign or a rule to use the DBCC, I am not sure when do I use them. How do I know that it is time to run some of those tests.
Ahmed

View 1 Replies View Related

Dbcc In 7.0

Feb 10, 1999

do you still have to run dbreindex in sql 7.0 ? the upgrade book was unclear on this subject.

View 1 Replies View Related

DBCC

Jul 10, 2000

After running dbcc checkdb: I see the error message "Extent ### is in the wrong Segment" and "Chain processed with bad segment for object ###"

Is this a indication that my database is corrupt?

View 3 Replies View Related

DBCC

Aug 2, 1999

Is there a way to view the script of DBCC statements provided by
SQL server

View 4 Replies View Related

How Do I Allow Non-SA To Use DBCC From VB App ?

Mar 15, 1999

Can I allow a non SA account to issue DBCC or TRUNCATE TABLE on a DBO table ?

I've tried setting this up in a SP where I've granted execute only to the user but the user receives "Only the DBO of the database may run the DBCC UPDATEUSAGE command".

Do I have to set the user up as an alias to DBO ? I'd rather not.

View 2 Replies View Related

BCP-DBCC ?

Jan 6, 1999

In past days we have a problem with a database. When we tried to fix the problem we found
that SQL 6.5 has a wizard for maintain the DB, but these one doesnt have an option to fix an
individual table. Seeing the way of work of this utility we look that it uses a bcp file.

What is the difference in :
1) apply a bcp(out) to an indivual table, drop the table, create table, bcp(in), create indexes.
We believe this method fixes the fragmentation problem
or
2) dbcc checktable(to the table).This method doesnt fix the fragmentation problem


Thanks in advance

View 2 Replies View Related

Dbcc

Sep 1, 2004

Does someone has a dbcc code that rebuild the indexes of my entire database?

View 8 Replies View Related

Dbcc

Apr 28, 2008

If we issue a DBCC command against a particulat databse, if it shows some inconsistency how can we repair it with out allowing any dataloss.

View 2 Replies View Related

Dbcc Dbreindex

Jan 7, 2002

We are new to SQL Server and we are currently setting up a job that
does a dbreindex for tables that need it. I got the scripts for this
from swynk. 50 of the tables that needed a dbreindex,
(under 90% scan density) were not impacted by running the dbreindex.
I.e., I ran the dbreindex and it left it at 50% scan density.
The fill factor for these tables is set to 100%.
I tried update stats, updateusage...nothing changes....
I am sure there must be a logical reason as to why the dbreindex
had no impact on these tables. Does any one have any info on this?
Thanks in advance!

View 4 Replies View Related

DBCC Reindex

Feb 19, 2002

Hi guys.
I an application here developed by a third party software house.
In the past, for some reason, the database would fail daily. The software
house recommended that we use dbcc reindex on all tables within the
databases twice daily. This was scheduled and is now running. Now the
database no longer fails.
The fix works and I don't understand why.
I don't understand why this would fix the problem. Why would reindex
twice daily solve the problem.
It seems excessive to have to reindex every user table twice daily.


Parg

View 1 Replies View Related

DBCC Options

May 4, 2002

anyone know about the undocument options of DBCC?
which options are undomented?
i.e.
log
There are only a few options which are documented in SQL Online Books
thank in advance

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved