MS SQL Server :: CHECKDB Errors Reported

CheckDB Errors

Jul 27, 2006

Hi,

Ran DBCC CHECKDB on my database and it's returning the following:

There are 460 rows in 13 pages for object 'KPW'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1977058079, index ID 0: Page (1:1868079) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1977058079, index ID 0, page (1:1868079), row 76. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 173 and 193.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1977058079, index ID 0, page (1:1868079), row 76. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 16374 and 33.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867931), slot 8, text ID 205274873856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867932), slot 0, text ID 205275004928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867932), slot 2, text ID 205275136000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1

Suggestions on how to troubleshoot/fix?

Thanks!

View 19 Replies View Related

DBCC CHECKDB Errors

Jun 3, 2008

I have a database that was handed to me which is getting the following errors:

DBCC CHECKDB ('DBName') returns:
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1, index ID 0, page (1:37). Test (m_freeCnt == freeCnt) failed. Values are 680 and 788.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:37) with latch type SH. sysobjects failed.

DBCC PAGE (DBName, 1, 37, 1) returns:
Server: Msg 8939, Level 16, State 20, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (m_slots[0].GetOffset () == PAGEHEADSIZE) failed. Values are 662 and 96.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(GAMHEADER) + sizeof(DataRecHdr))) failed. Values are 190 and 756.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC PAGE (DBName, 1, 2, 1) returns:
Server: Msg 8939, Level 16, State 20, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (m_slots[0].GetOffset () == PAGEHEADSIZE) failed. Values are 662 and 96.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(GAMHEADER) + sizeof(DataRecHdr))) failed. Values are 190 and 756.
Server: Msg 3624, Level 20, State 1, Line 1

Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 51
Process ID: 2096

Connection Broken

And finally, DBCC CHECKTABLE (sysobjects) WITH NO_INFOMSGS, ALL_ERRORMSGS gives me:
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1, index ID 0, page (1:37). Test (m_freeCnt == freeCnt) failed. Values are 680 and 788.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:37) with latch type SH. sysobjects failed.

I've looked at the MDF with a hex editor and there's definitely data in there. I have the DB attached and in single user/emergency mode, but DBCC isn't having much luck. Help?

View 9 Replies View Related

CHECKDB Failing To Fix Errors.

Feb 4, 2006

Hi,

I am running SQL Server 2000 with Service Pack 4. We recently had a rather nasty corruption problem over several of our databases on our server. It primarily affected indexes and page allocation tables. As of yet, we have yet to identify the cause of this problem. We ran hardware diagnostics and no problems were returned, and nothing aside from the errors that alerted us to the issue in the first place were found in the event logs or SQL error logs.

DBCC CHECKDB was ran several times (we ran it on all DBs on the server just to be safe, several came up corrupted) and used that to repair the data, but very quickly new corruptions popped up.

However, this is not the extent of my bewilderment. Due to the need to get our server back online, a couple co-workers decided to detatch the databases and reinstall the SQL server, then reattatch the databases and try and repair them. I am not sure why this would have mattered but it seems to have prevented any new corruptions.

Anyway, while I was repairing the problem databases to bring them back online, one of them has been giving me a particular problem. Several indexes were pretty thoroughly trashed, giving over 1000 consistency errors. There were also around 25 or so allocation errors. I rebuilt all of the indexes to remove the consistency errors, however the allocation errors still remain and CHECKDB will not remove them. Here are the results of my most recent checkdb repair attempt:

Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886000) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886112) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886224) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886424) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886520) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886656) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886736) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886936) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887024) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887176) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887344) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887464) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887624) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887816) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:887920) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888096) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888248) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888352) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888584) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Could not repair this error.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888704) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:888840) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:889024) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:889168) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:889328) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
CHECKDB found 24 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 24 allocation errors and 0 consistency errors in database 'PRODUCTION_CATEGORIZER'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PRODUCTION_CATEGORIZER repair_allow_data_loss).

As you can see, it is telling me that the errors cannot be repaired until other errors are corrected first, but there are no other errors! I cannot figure it out. The rest of our databases on the server are now clean, this is the only one that is not working. Does anyone have any suggestions before we restore to the last backup?

View 7 Replies View Related

Errors On Dbcc Checkdb

Oct 12, 2007

I've seen a lot of approaches to this, but I wanted to check here first before trying anything. Unfortunately, I just arrived and looking over the database, realized their backups have been failing for quite sometime. The application using the database is running fine so far, but backing it up freezes. I run DBCC CHECKDB (MyDB) WITH NO_INFOMSGS, ALL_ERRORMSGS and get:

Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 844424953200640 (type Unknown), page ID (1:26483) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2533274801405952 (type Unknown), page ID (1:24589) contains an incorrect page ID in its page header. The PageId in the page header = (0:-1694496760).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2533274811367424 (type Unknown), page ID (1:24301) contains an incorrect page ID in its page header. The PageId in the page header = (0:-1694496747).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2533279088508928 (type Unknown), page ID (1:24334) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
CHECKDB found 0 allocation errors and 4 consistency errors not associated with any single object.
Msg 8928, Level 16, State 1, Line 1
Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 71668789018624 (type In-row data): Page (1:22417) could not be processed. See other errors for details.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 71668789018624 (type In-row data). Page (1:521649) is missing a reference from previous page (1:22417). Possible chain linkage problem.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 353143765729280 (type In-row data), page (1:22417). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362185 and -1.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 353143765729280, alloc unit ID 353143765729280 (type In-row data). Page (1:22417) was not seen in the scan although its parent (1:479) and previous (1:715544) refer to it. Check any previous errors.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'WebGroups' (object ID 1093578934).
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1606680576 owned by data record identified by RID = (1:1620895:7)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1606811648 owned by data record identified by RID = (1:1620895:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1607073792 owned by data record identified by RID = (1:1620895:10)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1607204864 owned by data record identified by RID = (1:1620895:11)
Msg 8929, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 130617058000896 (type In-row data): Errors found in off-row data with ID 1608908800 owned by data record identified by RID = (1:1620896:10)
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24301) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24301), slot 0, text ID 1606680576 is referenced by page (1:24298), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24334) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24334), slot 0, text ID 1606811648 is referenced by page (1:24331), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24462) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data), page (1:24462). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362185 and -1.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24462), slot 0, text ID 1607073792 is referenced by page (1:24429), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:24589) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:24589), slot 0, text ID 1607204864 is referenced by page (1:24591), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data): Page (1:26483) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 1, partition ID 412092034711552, alloc unit ID 71906736119218176 (type LOB data). The off-row data node at page (1:26483), slot 0, text ID 1608908800 is referenced by page (1:26470), slot 0, but was not seen in the scan.
CHECKDB found 0 allocation errors and 16 consistency errors in table 'Docs' (object ID 1993058136).
CHECKDB found 0 allocation errors and 24 consistency errors in database 'MyDB'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MyDB).

View 5 Replies View Related

DBCC CHECKDB Errors

Jan 24, 2008

SQL 2005
I ran the following:
DBCC CHECKDB (��DATABASENAME��)
Errors are produced
DBCC CHECKDB ('DATABASENAME')

DBCC results for 'AllDocStreams'.
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:26839) in object ID 181575685, index ID 1, partition ID 293374720802816, alloc unit ID 71788018805309440 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.

I wanted to view the PAGE by doing

dbcc traceon(3604)

DBCC PAGE (1,26839,1)
(But keeps telling me there is no page)

So i tried
DBCC IND('TEST','AllDocStreams',1)
Found the PagePID of 26839 then i found IAMFID so i tried

DBCC PAGE (1,1577,3)
still no page

I was trying to find the PCT FULL on the page? but can't find the page its talking about.

I can do a REPAIR_WITH_DATA_LOSS but i wanted to figure out what it is actually repairing and what the message is really telling me

Thanks

View 4 Replies View Related

CHECKDB Found 12 Consistency Errors

Feb 27, 2012

My Maintenance plan is failing because of this error.

[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 569873197. The text, ntext, or image node at page (1:13952), slot 42, text ID 49266360320 is not referenced.

[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 12 consistency errors in table 'Orientation_ChkList' (object ID 569873197).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 12 consistency errors in database.

How can I check which rows in this table is corrupted? I have three image fields in this table. This is happening since long time and restore from backup won't work here.

View 5 Replies View Related

Dbcc Checkdb Errors Against Sql_variant

Feb 10, 2004

Recently, I've started to get DBCC Checkdb errors against a few databases - seems to be since applying sp3a.

The error (2537) affects certain tables that contain SQL_Variant fields. I just completed an exercise to run DBCC CHECKDB ('dbname', REPAIR_ALLOW_DATA_LOSS) against a copy of the offending table - then comparing the original table and the repaired table to isolate the rows that throw up the consistency errors. What I found was that all the rows trapped by DBCC CHECKDB for error 2537 contain real numbers in the SQL_Variant field. All other rows with text or integer contents in the SQL_Variant field do not throw up errors.

I tried a MS hotfix for error 2537 but it didn't fix the problem. Any ideas?

Clive

View 6 Replies View Related

CHECKDB: 97 Consistency Errors And None Repaired

May 11, 2006

Hi all,

I'm using WSUS2 to deploy software updates at my company, WSUS2 uses WMSDE (SQL Server Desktop Engine 2000 SP4) to store its database.

WSUS2 suddenly stopped working, I identified problems at the Database Log reading like this:

quote:
2006-05-11 12:17:52.64 spid54 Error: 7105, Severity: 22, State: 6
2006-05-11 12:17:52.64 spid54 Page (1:79), slot 29 for text, ntext, or image node does not exist..
[...]

So I ran a CHECKDB via osql on the commandline and got errors which should be repaired with a minimum of REPAIR_ALLOW_DATA_LOSS.

So I ran the following command on the corruprt Datebase 'SUSDB' after putting the DB into single user mode:

1> DBCC CHECKDB ('SUSDB',REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
2> GO

And I got the fowllowing output (condensed):

quote:
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131203072 owned by data record identified
by RID = (1:24:2) id = 1 and indid = 3.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131268608 owned by data record identified
by RID = (1:24:6) id = 3 and indid = 2.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131334144 owned by data record identified
by RID = (1:24:7) id = 4 and indid = 1.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131399680 owned by data record identified
by RID = (1:24:8) id = 4 and indid = 2.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131465216 owned by data record identified
by RID = (1:24:13) id = 10 and indid = 2.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 131530752 owned by data record identified
by RID = (1:24:15) id = 11 and indid = 1.

[... MANY MANY MORE OF THOSE FAILURES WITH DIFFERENT IDs ...]

Object ID 2: Errors found in text ID 459538432 owned by data record identified
by RID = (1:104:27) id = 1858105660 and indid = 3.
The repair level on the DBCC statement caused this repair to be
bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 459735040 owned by data record identified
by RID = (1:104:28) id = 1858105660 and indid = 4.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 4462411776 owned by data record identified
by RID = (1:107:5) id = 373576369 and indid = 6.
Msg 8929, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2: Errors found in text ID 327745536 owned by data record identified
by RID = (1:107:10) id = 487672785 and indid = 1.

[... MANY MANY MORE OF THOSE FAILURES WITH DIFFERENT IDs ...]

Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:64), slot
4, text ID 459735040 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:68), slot
7, text ID 197459968 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:69), slot
0, text ID 197263360 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:70), slot
0, text ID 4462411776 is not referenced.
Msg 8964, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:71), slot
5, text ID 197197824 is not referenced.
Msg 8928, Level 16, State 1, Server FILESWSUS, Line 1
Object ID 2, index ID 255: Page (1:79) could not be processed. See other errors
for details.
Msg 8965, Level 16, State 1, Server FILESWSUS, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:79), slot
0, text ID 327745536 is referenced by page (1:107), slot 10, but was not seen
in the scan.

[... MANY MANY MORE OF THOSE FAILURES WITH DIFFERENT IDs ...]

The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
The repair level on the DBCC statement caused this repair to be
bypassed.
CHECKDB found 0 allocation errors and 97 consistency errors in table
'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 97 consistency errors in database
'SUSDB'.

None of the errors are repaired, what can I do to repair the Database?

Thanks for any hints!

http://www.linuxhelpforum.de

View 5 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

DBCC CHECKDB Consistency Errors

Mar 14, 2007

Hi all,
Here is my DBCC CHECKDB output. I keep REPAIRing the problem and it keeps coming back. I would love to get rid of the objectID in question, but do not know how, or if that would fix the problem. This is running on a MSDE 2000 SP3a. It is also only the "Events" Table that seems to be affected.

Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67702), slots 174 and 175.
Server: Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 562101043, Index ID 2. Keys out of order on page (1:67875), slots 246 and 247.
DBCC results for 'AccessControl'.
DBCC results for 'sysobjects'.
There are 1130 rows in 20 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1397 rows in 55 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3047 rows in 47 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 572 rows in 52 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 51 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 1017 rows in 6 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 13 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 'GLOBAL_IO_LINKAGE'.
There are 0 rows in 0 pages for object 'GLOBAL_IO_LINKAGE'.
DBCC results for 'PANEL_USER_GROUP'.
There are 0 rows in 0 pages for object 'PANEL_USER_GROUP'.
DBCC results for 'PRECACGRP'.
There are 0 rows in 0 pages for object 'PRECACGRP'.
DBCC results for 'GLOBAL_IO_OUTPUT_ACTION'.
There are 0 rows in 0 pages for object 'GLOBAL_IO_OUTPUT_ACTION'.
DBCC results for 'PANEL_USER'.
There are 0 rows in 0 pages for object 'PANEL_USER'.
DBCC results for 'USERS_ACCESSLEVEL_LINK'.
There are 0 rows in 0 pages for object 'USERS_ACCESSLEVEL_LINK'.
DBCC results for 'PRECGRPLINK'.
There are 0 rows in 0 pages for object 'PRECGRPLINK'.
DBCC results for 'EMP_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'EMP_SEGMENT_LINK'.
DBCC results for 'KNOWHO_SERVER'.
There are 0 rows in 0 pages for object 'KNOWHO_SERVER'.
DBCC results for 'ASSET_MMOBJS'.
There are 0 rows in 0 pages for object 'ASSET_MMOBJS'.
DBCC results for 'GOS_MESSAGE'.
There are 1 rows in 1 pages for object 'GOS_MESSAGE'.
DBCC results for 'QUEUED_EVENTS'.
There are 0 rows in 1 pages for object 'QUEUED_EVENTS'.
DBCC results for 'DDTBL'.
There are 23 rows in 1 pages for object 'DDTBL'.
DBCC results for 'ACCESSLVL_ASSIGNABLE_SEGMENT'.
There are 0 rows in 0 pages for object 'ACCESSLVL_ASSIGNABLE_SEGMENT'.
DBCC results for 'PERSON_DATA_SOURCE'.
There are 6 rows in 1 pages for object 'PERSON_DATA_SOURCE'.
DBCC results for 'IE_BADGE_ACC'.
There are 0 rows in 0 pages for object 'IE_BADGE_ACC'.
DBCC results for 'DEPT'.
There are 1 rows in 1 pages for object 'DEPT'.
DBCC results for 'USER_PERM_REPORT_GROUP_MEMBER'.
There are 0 rows in 0 pages for object 'USER_PERM_REPORT_GROUP_MEMBER'.
DBCC results for 'DEVICE_GROUP'.
There are 3 rows in 1 pages for object 'DEVICE_GROUP'.
DBCC results for 'BADGE_AREA_LOCATION_REPL'.
There are 0 rows in 0 pages for object 'BADGE_AREA_LOCATION_REPL'.
DBCC results for 'ACCTRANS_RESTORED'.
There are 2478 rows in 47 pages for object 'ACCTRANS_RESTORED'.
DBCC results for 'LNL_CERTIFICATE'.
There are 0 rows in 0 pages for object 'LNL_CERTIFICATE'.
DBCC results for 'TRANSMITTER'.
There are 0 rows in 0 pages for object 'TRANSMITTER'.
DBCC results for 'DEVICE_GROUP_LINK'.
There are 186 rows in 1 pages for object 'DEVICE_GROUP_LINK'.
DBCC results for 'ALARM_ACK_ACTION'.
There are 0 rows in 0 pages for object 'ALARM_ACK_ACTION'.
DBCC results for 'ACCTRANS_REPL'.
There are 0 rows in 0 pages for object 'ACCTRANS_REPL'.
DBCC results for 'CERTIFICATE_AUTHORITY'.
There are 0 rows in 0 pages for object 'CERTIFICATE_AUTHORITY'.
DBCC results for 'ACCTRANS'.
There are 22500 rows in 435 pages for object 'ACCTRANS'.
DBCC results for 'DIALUP'.
There are 0 rows in 0 pages for object 'DIALUP'.
DBCC results for 'ICONTYPE_COMMAND'.
There are 3 rows in 1 pages for object 'ICONTYPE_COMMAND'.
DBCC results for 'CARDHOLDER_ACCOUNT'.
There are 0 rows in 0 pages for object 'CARDHOLDER_ACCOUNT'.
DBCC results for 'ACCESSLVL_EXTENDED'.
There are 0 rows in 0 pages for object 'ACCESSLVL_EXTENDED'.
DBCC results for 'RDR_CARDFORMATS'.
There are 0 rows in 0 pages for object 'RDR_CARDFORMATS'.
DBCC results for 'DIVISION'.
There are 1 rows in 1 pages for object 'DIVISION'.
DBCC results for 'MOBILE_VERIFY_GATE'.
There are 0 rows in 0 pages for object 'MOBILE_VERIFY_GATE'.
DBCC results for 'DOWNLOADDB'.
There are 0 rows in 0 pages for object 'DOWNLOADDB'.
DBCC results for 'ACCGPLINK'.
There are 0 rows in 0 pages for object 'ACCGPLINK'.
DBCC results for 'ARCHIVE_SERVER'.
There are 1 rows in 1 pages for object 'ARCHIVE_SERVER'.
DBCC results for 'RDTZCTLIST'.
There are 0 rows in 0 pages for object 'RDTZCTLIST'.
DBCC results for 'ELEVATORHW'.
There are 0 rows in 0 pages for object 'ELEVATORHW'.
DBCC results for 'ACCLVLINK'.
There are 0 rows in 0 pages for object 'ACCLVLINK'.
DBCC results for 'ARCHIVE_SERVER_LOCATION'.
There are 1 rows in 1 pages for object 'ARCHIVE_SERVER_LOCATION'.
DBCC results for 'BDG2TRN'.
There are 0 rows in 0 pages for object 'BDG2TRN'.
DBCC results for 'READER'.
There are 0 rows in 0 pages for object 'READER'.
DBCC results for 'MOBILE_VERIFY_GATE_RDR_LINK'.
There are 0 rows in 0 pages for object 'MOBILE_VERIFY_GATE_RDR_LINK'.
DBCC results for 'TRANSMITTER_INPUT'.
There are 0 rows in 0 pages for object 'TRANSMITTER_INPUT'.
DBCC results for 'EVENT'.
There are 1249 rows in 11 pages for object 'EVENT'.
DBCC results for 'USER_OPTIONS'.
There are 5 rows in 1 pages for object 'USER_OPTIONS'.
DBCC results for 'NV_FIRMWARE_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'NV_FIRMWARE_DOWNLOAD_ACTION'.
DBCC results for 'READER_ENTRANCE'.
There are 0 rows in 0 pages for object 'READER_ENTRANCE'.
DBCC results for 'TRANSMITTER_LINK'.
There are 0 rows in 0 pages for object 'TRANSMITTER_LINK'.
DBCC results for 'EA_DIAGNOSTIC_CFG'.
There are 0 rows in 0 pages for object 'EA_DIAGNOSTIC_CFG'.
DBCC results for 'NV_FIRMWARE_DOWNLOAD_DEVICE'.
There are 0 rows in 0 pages for object 'NV_FIRMWARE_DOWNLOAD_DEVICE'.
DBCC results for 'READER_ENTRANCE_LOITERING'.
There are 0 rows in 0 pages for object 'READER_ENTRANCE_LOITERING'.
DBCC results for 'RELAYOUTPT'.
There are 0 rows in 0 pages for object 'RELAYOUTPT'.
DBCC results for 'EVENT_GIOFUNCLISTLINK'.
There are 0 rows in 0 pages for object 'EVENT_GIOFUNCLISTLINK'.
DBCC results for 'ACISLOG'.
There are 8 rows in 1 pages for object 'ACISLOG'.
DBCC results for 'VISIT_TYPE'.
There are 1 rows in 1 pages for object 'VISIT_TYPE'.
DBCC results for 'BADGE_EXPECTED_PASSAGE'.
There are 0 rows in 0 pages for object 'BADGE_EXPECTED_PASSAGE'.
DBCC results for 'ALARM'.
There are 1249 rows in 18 pages for object 'ALARM'.
DBCC results for 'EA_RESULTCOL_CFG'.
There are 1 rows in 1 pages for object 'EA_RESULTCOL_CFG'.
DBCC results for 'REPORTCFG'.
There are 126 rows in 5 pages for object 'REPORTCFG'.
DBCC results for 'EVENTGRP'.
There are 1 rows in 1 pages for object 'EVENTGRP'.
DBCC results for 'VISIT_RESTORED'.
There are 0 rows in 0 pages for object 'VISIT_RESTORED'.
DBCC results for 'SNMP_MIB_DATA'.
There are 0 rows in 0 pages for object 'SNMP_MIB_DATA'.
DBCC results for 'ALARMINPUT'.
There are 48 rows in 2 pages for object 'ALARMINPUT'.
DBCC results for 'EA_RESULTCOL_DDFLD_LINK'.
There are 5 rows in 1 pages for object 'EA_RESULTCOL_DDFLD_LINK'.
DBCC results for 'RESISTOR'.
There are 0 rows in 0 pages for object 'RESISTOR'.
DBCC results for 'EVENTGRPLNK'.
There are 316 rows in 2 pages for object 'EVENTGRPLNK'.
DBCC results for 'GOS_EA_ALERT'.
There are 0 rows in 0 pages for object 'GOS_EA_ALERT'.
DBCC results for 'EVENTS_VIDEO_RESTORED'.
There are 0 rows in 0 pages for object 'EVENTS_VIDEO_RESTORED'.
DBCC results for 'SNMP_AGENT'.
There are 0 rows in 0 pages for object 'SNMP_AGENT'.
DBCC results for 'ALARMMASKGROUP'.
There are 0 rows in 0 pages for object 'ALARMMASKGROUP'.
DBCC results for 'USER_LNL_DB_LINK'.
There are 0 rows in 0 pages for object 'USER_LNL_DB_LINK'.
DBCC results for 'SAVEDEVENTS'.
There are 2611 rows in 41 pages for object 'SAVEDEVENTS'.
DBCC results for 'EVENT_PARAM'.
There are 340 rows in 4 pages for object 'EVENT_PARAM'.
DBCC results for 'ACTION_REPLICATOR'.
There are 0 rows in 0 pages for object 'ACTION_REPLICATOR'.
DBCC results for 'OPC_SOURCE'.
There are 0 rows in 0 pages for object 'OPC_SOURCE'.
DBCC results for 'ALARMMASKGROUPLINK'.
There are 0 rows in 0 pages for object 'ALARMMASKGROUPLINK'.
DBCC results for 'AUTO_TOUR_ACTION'.
There are 0 rows in 0 pages for object 'AUTO_TOUR_ACTION'.
DBCC results for 'VERSIT'.
There are 29 rows in 1 pages for object 'VERSIT'.
DBCC results for 'EVENT_TO_EVENT_PARAM_LINK'.
There are 936 rows in 3 pages for object 'EVENT_TO_EVENT_PARAM_LINK'.
DBCC results for 'USER_PTZ_PRIORITY'.
There are 4 rows in 1 pages for object 'USER_PTZ_PRIORITY'.
DBCC results for 'GSC'.
There are 46 rows in 1 pages for object 'GSC'.
DBCC results for 'ALARMPANEL'.
There are 4 rows in 1 pages for object 'ALARMPANEL'.
DBCC results for 'AUTO_TOUR_MONSTATION_LINK'.
There are 0 rows in 0 pages for object 'AUTO_TOUR_MONSTATION_LINK'.
DBCC results for 'ASSET_CLASS'.
There are 0 rows in 0 pages for object 'ASSET_CLASS'.
DBCC results for 'EVENTS'.
There are 3692794 rows in 53947 pages for object 'EVENTS'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'EVENTS' (object ID 562101043).
DBCC results for 'LNL_DIRECTORY'.
There are 1 rows in 1 pages for object 'LNL_DIRECTORY'.
DBCC results for 'SWEVENT_GUARANTEE'.
There are 0 rows in 0 pages for object 'SWEVENT_GUARANTEE'.
DBCC results for 'DMV'.
There are 29 rows in 1 pages for object 'DMV'.
DBCC results for 'ASSET_GROUP_ASSET_CLASS_LINK'.
There are 0 rows in 0 pages for object 'ASSET_GROUP_ASSET_CLASS_LINK'.
DBCC results for 'PTZ_PRIORITY_LOCK'.
There are 0 rows in 0 pages for object 'PTZ_PRIORITY_LOCK'.
DBCC results for 'ALARMPANELLINKS'.
There are 0 rows in 0 pages for object 'ALARMPANELLINKS'.
DBCC results for 'IVCHANNELCONFIG'.
There are 0 rows in 0 pages for object 'IVCHANNELCONFIG'.
DBCC results for 'EVENTS_GUARANTEE'.
There are 0 rows in 0 pages for object 'EVENTS_GUARANTEE'.
DBCC results for 'CAC'.
There are 41 rows in 1 pages for object 'CAC'.
DBCC results for 'ASSET_ASSET_CLASS_LINK'.
There are 0 rows in 0 pages for object 'ASSET_ASSET_CLASS_LINK'.
DBCC results for 'SEGMENT_GROUP_MEMBER'.
There are 0 rows in 0 pages for object 'SEGMENT_GROUP_MEMBER'.
DBCC results for 'ALARMSACK'.
There are 30309 rows in 239 pages for object 'ALARMSACK'.
DBCC results for 'EVENTS_GUARANTEE_DONE'.
There are 0 rows in 0 pages for object 'EVENTS_GUARANTEE_DONE'.
DBCC results for 'CISCO_AIC_DEVICE'.
There are 0 rows in 0 pages for object 'CISCO_AIC_DEVICE'.
DBCC results for 'CAMERA_PRESET_TOUR'.
There are 0 rows in 0 pages for object 'CAMERA_PRESET_TOUR'.
DBCC results for 'CHASSIS'.
There are 3 rows in 1 pages for object 'CHASSIS'.
DBCC results for 'STAZONLINK'.
There are 4 rows in 1 pages for object 'STAZONLINK'.
DBCC results for 'EVENTS_LASTSERIALNUM'.
There are 44 rows in 1 pages for object 'EVENTS_LASTSERIALNUM'.
DBCC results for 'ALARMSACK_RESTORED'.
There are 0 rows in 0 pages for object 'ALARMSACK_RESTORED'.
DBCC results for 'USER_ACCOUNT'.
There are 23 rows in 4 pages for object 'USER_ACCOUNT'.
DBCC results for 'TWO_MAN_TYPE'.
There are 3 rows in 1 pages for object 'TWO_MAN_TYPE'.
DBCC results for 'PURGE_HISTORYLOGS_ACTION'.
There are 0 rows in 0 pages for object 'PURGE_HISTORYLOGS_ACTION'.
DBCC results for 'CAMERA_PRESET_COMMAND'.
There are 0 rows in 0 pages for object 'CAMERA_PRESET_COMMAND'.
DBCC results for 'LOCKSET_MEMORY'.
There are 1 rows in 1 pages for object 'LOCKSET_MEMORY'.
DBCC results for 'SYSTEMCARDS'.
There are 1 rows in 1 pages for object 'SYSTEMCARDS'.
DBCC results for 'EVENTS_RESTORED'.
There are 0 rows in 0 pages for object 'EVENTS_RESTORED'.
DBCC results for 'ARCHIVE_CONFIG'.
There are 6 rows in 1 pages for object 'ARCHIVE_CONFIG'.
DBCC results for 'SINGLE_DEVICE_ACTION'.
There are 0 rows in 0 pages for object 'SINGLE_DEVICE_ACTION'.
DBCC results for 'SWEVENT_GUARANTEE_DONE'.
There are 0 rows in 0 pages for object 'SWEVENT_GUARANTEE_DONE'.
DBCC results for 'PROCESSORTYPE'.
There are 3 rows in 1 pages for object 'PROCESSORTYPE'.
DBCC results for 'HWTRANS_REPL'.
There are 0 rows in 0 pages for object 'HWTRANS_REPL'.
DBCC results for 'IVPROCESSORS_IN_USE'.
There are 1 rows in 1 pages for object 'IVPROCESSORS_IN_USE'.
DBCC results for 'ARCHIVE_DETAIL'.
There are 29 rows in 1 pages for object 'ARCHIVE_DETAIL'.
DBCC results for 'DEVICE_GROUP_ACTION'.
There are 0 rows in 0 pages for object 'DEVICE_GROUP_ACTION'.
DBCC results for 'EVENTCRITERIA'.
There are 0 rows in 0 pages for object 'EVENTCRITERIA'.
DBCC results for 'WORLDTZ_BAK'.
There are 62 rows in 2 pages for object 'WORLDTZ_BAK'.
DBCC results for 'AREAAPB'.
There are 1 rows in 1 pages for object 'AREAAPB'.
DBCC results for 'MUSTER_INITIATION_ACTION'.
There are 0 rows in 0 pages for object 'MUSTER_INITIATION_ACTION'.
DBCC results for 'TEXT_BASED_EVENTS'.
There are 0 rows in 0 pages for object 'TEXT_BASED_EVENTS'.
DBCC results for 'EVENTS_REPL'.
There are 0 rows in 0 pages for object 'EVENTS_REPL'.
DBCC results for 'SUPPORTED_BIOMETRIC_TYPES'.
There are 0 rows in 0 pages for object 'SUPPORTED_BIOMETRIC_TYPES'.
DBCC results for 'TEXTOBJ'.
There are 1249 rows in 13 pages for object 'TEXTOBJ'.
DBCC results for 'EVENTYPE'.
There are 27 rows in 1 pages for object 'EVENTYPE'.
DBCC results for 'ASSET_TYPE'.
There are 1 rows in 1 pages for object 'ASSET_TYPE'.
DBCC results for 'AREATZCTLIST'.
There are 0 rows in 0 pages for object 'AREATZCTLIST'.
DBCC results for 'SWEVENT'.
There are 0 rows in 0 pages for object 'SWEVENT'.
DBCC results for 'TIMEZONE'.
There are 5 rows in 1 pages for object 'TIMEZONE'.
DBCC results for 'EVTALMLINK'.
There are 1249 rows in 6 pages for object 'EVTALMLINK'.
DBCC results for 'ASSET_SUBTYPE'.
There are 1 rows in 1 pages for object 'ASSET_SUBTYPE'.
DBCC results for 'POS_REGISTER'.
There are 0 rows in 0 pages for object 'POS_REGISTER'.
DBCC results for 'MU_ALARM_MASK_GROUP_ACTION'.
There are 0 rows in 0 pages for object 'MU_ALARM_MASK_GROUP_ACTION'.
DBCC results for 'TITLE'.
There are 1 rows in 1 pages for object 'TITLE'.
DBCC results for 'ASSET_LASTLOCATION'.
There are 0 rows in 0 pages for object 'ASSET_LASTLOCATION'.
DBCC results for 'REPL_SCHEDULE'.
There are 0 rows in 0 pages for object 'REPL_SCHEDULE'.
DBCC results for 'TRANSLOG'.
There are 0 rows in 0 pages for object 'TRANSLOG'.
DBCC results for 'VISITOR_SIGNOUT_ACTION'.
There are 0 rows in 0 pages for object 'VISITOR_SIGNOUT_ACTION'.
DBCC results for 'ARCHIVE_PURGE_DATABASE_ACTION'.
There are 1 rows in 1 pages for object 'ARCHIVE_PURGE_DATABASE_ACTION'.
DBCC results for 'TZINTERVAL'.
There are 6 rows in 1 pages for object 'TZINTERVAL'.
DBCC results for 'FAILEDRPC'.
There are 0 rows in 1 pages for object 'FAILEDRPC'.
DBCC results for 'ASSET_GROUP'.
There are 1 rows in 1 pages for object 'ASSET_GROUP'.
DBCC results for 'CONTINUOUS_VIDEO'.
There are 0 rows in 0 pages for object 'CONTINUOUS_VIDEO'.
DBCC results for 'DEACTIVATE_BADGE_ACTION'.
There are 0 rows in 0 pages for object 'DEACTIVATE_BADGE_ACTION'.
DBCC results for 'INTERCOM_CALL_ACTION'.
There are 0 rows in 0 pages for object 'INTERCOM_CALL_ACTION'.
DBCC results for 'UDFEMP'.
There are 1 rows in 1 pages for object 'UDFEMP'.
DBCC results for 'EMP'.
There are 1 rows in 1 pages for object 'EMP'.
DBCC results for 'FLOORLINK'.
There are 128 rows in 1 pages for object 'FLOORLINK'.
DBCC results for 'CHANGE_PASSWORD_ACTION'.
There are 0 rows in 0 pages for object 'CHANGE_PASSWORD_ACTION'.
DBCC results for 'ISC_DATABASE_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'ISC_DATABASE_DOWNLOAD_ACTION'.
DBCC results for 'LNL_RELATION'.
There are 11 rows in 1 pages for object 'LNL_RELATION'.
DBCC results for 'UDFOBJS'.
There are 202 rows in 7 pages for object 'UDFOBJS'.
DBCC results for 'NET_DOMAIN'.
There are 0 rows in 0 pages for object 'NET_DOMAIN'.
DBCC results for 'FLOORLIST'.
There are 3 rows in 1 pages for object 'FLOORLIST'.
DBCC results for 'CHANGE_PASSWORD_DEVICE'.
There are 0 rows in 0 pages for object 'CHANGE_PASSWORD_DEVICE'.
DBCC results for 'CARD_PRINTER_TYPE'.
There are 8 rows in 1 pages for object 'CARD_PRINTER_TYPE'.
DBCC results for 'ISC_DATABASE_DOWNLOAD_PANEL'.
There are 0 rows in 0 pages for object 'ISC_DATABASE_DOWNLOAD_PANEL'.
DBCC results for 'IVAPPLICATION'.
There are 0 rows in 0 pages for object 'IVAPPLICATION'.
DBCC results for 'NET_EMP_SID'.
There are 0 rows in 0 pages for object 'NET_EMP_SID'.
DBCC results for 'GIOFUNCLIST'.
There are 0 rows in 0 pages for object 'GIOFUNCLIST'.
DBCC results for 'TEXT_LIBRARY'.
There are 0 rows in 0 pages for object 'TEXT_LIBRARY'.
DBCC results for 'SEGMENT'.
There are 1 rows in 1 pages for object 'SEGMENT'.
DBCC results for 'ISC_FIRMWARE_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'ISC_FIRMWARE_DOWNLOAD_ACTION'.
DBCC results for 'ENCODER'.
There are 0 rows in 0 pages for object 'ENCODER'.
DBCC results for 'GIOFUNCLISTLINK'.
There are 0 rows in 0 pages for object 'GIOFUNCLISTLINK'.
DBCC results for 'IVAPPLICATIONTYPE'.
There are 0 rows in 0 pages for object 'IVAPPLICATIONTYPE'.
DBCC results for 'CCTVDEVICE_FAILOVER'.
There are 0 rows in 0 pages for object 'CCTVDEVICE_FAILOVER'.
DBCC results for 'HOLIDAYS'.
There are 1 rows in 1 pages for object 'HOLIDAYS'.
DBCC results for 'ISC_FIRMWARE_DOWNLOAD_PANEL'.
There are 0 rows in 0 pages for object 'ISC_FIRMWARE_DOWNLOAD_PANEL'.
DBCC results for 'IVAPP_CRITERIA_LOCK'.
There are 0 rows in 0 pages for object 'IVAPP_CRITERIA_LOCK'.
DBCC results for 'UDFPAGES'.
There are 2 rows in 1 pages for object 'UDFPAGES'.
DBCC results for 'USER_PERM_DEVICE_GROUP_LINK'.
There are 0 rows in 0 pages for object 'USER_PERM_DEVICE_GROUP_LINK'.
DBCC results for 'PTZ_SERVER_TYPE'.
There are 5 rows in 1 pages for object 'PTZ_SERVER_TYPE'.
DBCC results for 'HOLIDAY_TYPE'.
There are 8 rows in 1 pages for object 'HOLIDAY_TYPE'.
DBCC results for 'RESET_GLOBAL_APB_ACTION'.
There are 0 rows in 0 pages for object 'RESET_GLOBAL_APB_ACTION'.
DBCC results for 'PANEL_SELECTIVE_DOWNLOAD'.
There are 0 rows in 0 pages for object 'PANEL_SELECTIVE_DOWNLOAD'.
DBCC results for 'USER_PERM'.
There are 12 rows in 1 pages for object 'USER_PERM'.
DBCC results for 'ACCTRANS_OPERATION'.
There are 60 rows in 1 pages for object 'ACCTRANS_OPERATION'.
DBCC results for 'BADGETYPE_CARDFORMAT_LINK'.
There are 0 rows in 0 pages for object 'BADGETYPE_CARDFORMAT_LINK'.
DBCC results for 'AIMS'.
There are 0 rows in 0 pages for object 'AIMS'.
DBCC results for 'HOLIDAY_LNK'.
There are 1 rows in 1 pages for object 'HOLIDAY_LNK'.
DBCC results for 'RESET_GLOBAL_APB_SEGMENT'.
There are 0 rows in 0 pages for object 'RESET_GLOBAL_APB_SEGMENT'.
DBCC results for 'ACCTRANS_OBJECT'.
There are 128 rows in 1 pages for object 'ACCTRANS_OBJECT'.
DBCC results for 'USER_PERM_UDF'.
There are 2 rows in 1 pages for object 'USER_PERM_UDF'.
DBCC results for 'IDS_ALLOCATED'.
There are 0 rows in 0 pages for object 'IDS_ALLOCATED'.
DBCC results for 'REPORT_PRINT_ACTION'.
There are 0 rows in 0 pages for object 'REPORT_PRINT_ACTION'.
DBCC results for 'BADGE_ENCODING'.
There are 0 rows in 0 pages for object 'BADGE_ENCODING'.
DBCC results for 'LASTLOCATION_REPL'.
There are 0 rows in 0 pages for object 'LASTLOCATION_REPL'.
DBCC results for 'USER_PERM_UDF_FIELDS'.
There are 161 rows in 2 pages for object 'USER_PERM_UDF_FIELDS'.
DBCC results for 'IE_ACISFLDS'.
There are 0 rows in 0 pages for object 'IE_ACISFLDS'.
DBCC results for 'CONTINUOUS_VIDEO_RESTORED'.
There are 0 rows in 0 pages for object 'CONTINUOUS_VIDEO_RESTORED'.
DBCC results for 'DESERVERHOST'.
There are 0 rows in 0 pages for object 'DESERVERHOST'.
DBCC results for 'USER_PERM_UDF_PAGES'.
There are 2 rows in 1 pages for object 'USER_PERM_UDF_PAGES'.
DBCC results for 'IE_ACISINI'.
There are 0 rows in 0 pages for object 'IE_ACISINI'.
DBCC results for 'LASTLOCATION_REPL_STAGE'.
There are 0 rows in 0 pages for object 'LASTLOCATION_REPL_STAGE'.
DBCC results for 'CCTVDEVICE_IO'.
There are 0 rows in 0 pages for object 'CCTVDEVICE_IO'.
DBCC results for 'IE_RELATION'.
There are 0 rows in 0 pages for object 'IE_RELATION'.
DBCC results for 'ASSET'.
There are 0 rows in 0 pages for object 'ASSET'.
DBCC results for 'DE_ACTION'.
There are 0 rows in 0 pages for object 'DE_ACTION'.
DBCC results for 'ACCOUNT'.
There are 0 rows in 0 pages for object 'ACCOUNT'.
DBCC results for 'USER_PERM_REPORT_GROUP'.
There are 0 rows in 0 pages for object 'USER_PERM_REPORT_GROUP'.
DBCC results for 'INTERCOM_STATION'.
There are 0 rows in 0 pages for object 'INTERCOM_STATION'.
DBCC results for 'LNL_DEFAULT'.
There are 0 rows in 0 pages for object 'LNL_DEFAULT'.
DBCC results for 'DE_CONDITION'.
There are 0 rows in 0 pages for object 'DE_CONDITION'.
DBCC results for 'USERS'.
There are 24 rows in 1 pages for object 'USERS'.
DBCC results for 'DE_CONFIGURATION'.
There are 0 rows in 0 pages for object 'DE_CONFIGURATION'.
DBCC results for 'ACCOUNT_ZONE'.
There are 0 rows in 0 pages for object 'ACCOUNT_ZONE'.
DBCC results for 'LASTLOCATION'.
There are 0 rows in 0 pages for object 'LASTLOCATION'.
DBCC results for 'ASSET_ASSIGNMENT'.
There are 0 rows in 0 pages for object 'ASSET_ASSIGNMENT'.
DBCC results for 'ACCOUNT_AREA'.
There are 0 rows in 0 pages for object 'ACCOUNT_AREA'.
DBCC results for 'LOGON_AUTH'.
There are 1 rows in 1 pages for object 'LOGON_AUTH'.
DBCC results for 'USER_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'USER_SEGMENT_LINK'.
DBCC results for 'MONITOR_CCTV_DEVICE_LINK'.
There are 0 rows in 0 pages for object 'MONITOR_CCTV_DEVICE_LINK'.
DBCC results for 'LAYGRAPH'.
There are 6 rows in 1 pages for object 'LAYGRAPH'.
DBCC results for 'AUDIO'.
There are 0 rows in 0 pages for object 'AUDIO'.
DBCC results for 'DE_EXCHANGE_MAP'.
There are 0 rows in 0 pages for object 'DE_EXCHANGE_MAP'.
DBCC results for 'EVENT_CODE_TEMPLATE'.
There are 18 rows in 1 pages for object 'EVENT_CODE_TEMPLATE'.
DBCC results for 'VISITOR_UDF'.
There are 0 rows in 0 pages for object 'VISITOR_UDF'.
DBCC results for 'DE_EXPRESSION'.
There are 0 rows in 0 pages for object 'DE_EXPRESSION'.
DBCC results for 'LAYOUTS'.
There are 1 rows in 1 pages for object 'LAYOUTS'.
DBCC results for 'BADGE'.
There are 1 rows in 1 pages for object 'BADGE'.
DBCC results for 'DE_IO_DEFINITION'.
There are 0 rows in 0 pages for object 'DE_IO_DEFINITION'.
DBCC results for 'BADGE_USES_LEFT_PER_PANEL'.
There are 0 rows in 0 pages for object 'BADGE_USES_LEFT_PER_PANEL'.
DBCC results for 'EVENT_CODE_MAP'.
There are 1284 rows in 6 pages for object 'EVENT_CODE_MAP'.
DBCC results for 'VISIT'.
There are 0 rows in 0 pages for object 'VISIT'.
DBCC results for 'DE_IO_SET_DEFINITION'.
There are 0 rows in 0 pages for object 'DE_IO_SET_DEFINITION'.
DBCC results for 'LINEPRINTER_COLUMN'.
There are 0 rows in 0 pages for object 'LINEPRINTER_COLUMN'.
DBCC results for 'DE_IO_SET_LINK'.
There are 0 rows in 0 pages for object 'DE_IO_SET_LINK'.
DBCC results for 'TOUR'.
There are 0 rows in 0 pages for object 'TOUR'.
DBCC results for 'WORLDTZ'.
There are 85 rows in 2 pages for object 'WORLDTZ'.
DBCC results for 'DE_IO_SET_UNIT'.
There are 0 rows in 0 pages for object 'DE_IO_SET_UNIT'.
DBCC results for 'LINEPRINTER_LAYOUT'.
There are 0 rows in 0 pages for object 'LINEPRINTER_LAYOUT'.
DBCC results for 'TOUR_CHECKPOINT'.
There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT'.
DBCC results for 'WRKLAYLNK'.
There are 0 rows in 0 pages for object 'WRKLAYLNK'.
DBCC results for 'DE_LOOKUP_PARAM'.
There are 0 rows in 0 pages for object 'DE_LOOKUP_PARAM'.
DBCC results for 'LINKAGESERVERHOST'.
There are 1 rows in 1 pages for object 'LINKAGESERVERHOST'.
DBCC results for 'LINXPROCCMDS'.
There are 0 rows in 0 pages for object 'LINXPROCCMDS'.
DBCC results for 'TOUR_CHECKPOINT_ACTION'.
There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT_ACTION'.
DBCC results for 'DE_OPERATION'.
There are 0 rows in 0 pages for object 'DE_OPERATION'.
DBCC results for 'LNR_SOURCE_CAPS'.
There are 0 rows in 0 pages for object 'LNR_SOURCE_CAPS'.
DBCC results for 'GOS_DEVICE'.
There are 1 rows in 1 pages for object 'GOS_DEVICE'.
DBCC results for 'LNLCONFIG'.
There are 18 rows in 2 pages for object 'LNLCONFIG'.
DBCC results for 'BADGELINK'.
There are 0 rows in 0 pages for object 'BADGELINK'.
DBCC results for 'TOUR_CHECKPOINT_MESSAGE'.
There are 0 rows in 0 pages for object 'TOUR_CHECKPOINT_MESSAGE'.
DBCC results for 'FIRE_DEVICES'.
There are 0 rows in 0 pages for object 'FIRE_DEVICES'.
DBCC results for 'LNL_DB'.
There are 0 rows in 0 pages for object 'LNL_DB'.
DBCC results for 'BADGETYP'.
There are 4 rows in 1 pages for object 'BADGETYP'.
DBCC results for 'TOUR_MONSTATION'.
There are 0 rows in 0 pages for object 'TOUR_MONSTATION'.
DBCC results for 'FIRE_DEVICE_INPUTS_OUTPUTS'.
There are 0 rows in 0 pages for object 'FIRE_DEVICE_INPUTS_OUTPUTS'.
DBCC results for 'GOS_ALARMMESSAGELINK'.
There are 1 rows in 1 pages for object 'GOS_ALARMMESSAGELINK'.
DBCC results for 'BADGEID_RANGE'.
There are 0 rows in 0 pages for object 'BADGEID_RANGE'.
DBCC results for 'TOUR_LIST'.
There are 0 rows in 0 pages for object 'TOUR_LIST'.
DBCC results for 'RESET_USE_LIMIT_ACTION'.
There are 0 rows in 0 pages for object 'RESET_USE_LIMIT_ACTION'.
DBCC results for 'GOS_RECIPIENT'.
There are 0 rows in 1 pages for object 'GOS_RECIPIENT'.
DBCC results for 'TOUR_LIST_LINK'.
There are 0 rows in 0 pages for object 'TOUR_LIST_LINK'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'LOCATION'.
There are 1 rows in 1 pages for object 'LOCATION'.
DBCC results for 'RESET_USE_LIMIT_PANEL'.
There are 0 rows in 0 pages for object 'RESET_USE_LIMIT_PANEL'.
DBCC results for 'GOS_RECIPIENTADDRESS'.
There are 0 rows in 1 pages for object 'GOS_RECIPIENTADDRESS'.
DBCC results for 'LPRIORITY'.
There are 4 rows in 1 pages for object 'LPRIORITY'.
DBCC results for 'TOUR_EMP_TOUR_LIST_LINK'.
There are 0 rows in 0 pages for object 'TOUR_EMP_TOUR_LIST_LINK'.
DBCC results for 'EOL_TABLE'.
There are 4 rows in 1 pages for object 'EOL_TABLE'.
DBCC results for 'GOS_MESSAGERECIPIENT'.
There are 0 rows in 1 pages for object 'GOS_MESSAGERECIPIENT'.
DBCC results for 'MAP'.
There are 1 rows in 1 pages for object 'MAP'.
DBCC results for 'TOUR_LOG'.
There are 0 rows in 0 pages for object 'TOUR_LOG'.
DBCC results for 'EOL_TABLE_LINK'.
There are 0 rows in 0 pages for object 'EOL_TABLE_LINK'.
DBCC results for 'ALARMVIDEOCONFIG'.
There are 4 rows in 1 pages for object 'ALARMVIDEOCONFIG'.
DBCC results for 'MAPICON'.
There are 134 rows in 2 pages for object 'MAPICON'.
DBCC results for 'BADGETYPE_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'BADGETYPE_SEGMENT_LINK'.
DBCC results for 'INTRUSION_DEVICE'.
There are 0 rows in 0 pages for object 'INTRUSION_DEVICE'.
DBCC results for 'MAPICONGRP'.
There are 43 rows in 1 pages for object 'MAPICONGRP'.
DBCC results for 'ACTION_TYPE'.
There are 38 rows in 1 pages for object 'ACTION_TYPE'.
DBCC results for 'CCTV_DEVICE_LINK'.
There are 94 rows in 3 pages for object 'CCTV_DEVICE_LINK'.
DBCC results for 'BADGSTAT'.
There are 4 rows in 1 pages for object 'BADGSTAT'.
DBCC results for 'CAMERATYPE'.
There are 37 rows in 1 pages for object 'CAMERATYPE'.
DBCC results for 'MAPICONGRP_MEMBER'.
There are 143 rows in 1 pages for object 'MAPICONGRP_MEMBER'.
DBCC results for 'ACTION'.
There are 1 rows in 1 pages for object 'ACTION'.
DBCC results for 'CCTVDEVICE'.
There are 202 rows in 10 pages for object 'CCTVDEVICE'.
DBCC results for 'SERVERCAMERATYPE'.
There are 37 rows in 1 pages for object 'SERVERCAMERATYPE'.
DBCC results for 'MAPITEM'.
There are 48 rows in 1 pages for object 'MAPITEM'.
DBCC results for 'ACTION_LOG'.
There are 29 rows in 1 pages for object 'ACTION_LOG'.
DBCC results for 'BDGPRECLINK'.
There are 0 rows in 0 pages for object 'BDGPRECLINK'.
DBCC results for 'VISIT_EMAIL_LINK'.
There are 0 rows in 0 pages for object 'VISIT_EMAIL_LINK'.
DBCC results for 'DEFAULTMAPICON'.
There are 56 rows in 1 pages for object 'DEFAULTMAPICON'.
DBCC results for 'BDGREQFLDLINK'.
There are 0 rows in 0 pages for object 'BDGREQFLDLINK'.
DBCC results for 'ACTION_GROUP'.
There are 0 rows in 1 pages for object 'ACTION_GROUP'.
DBCC results for 'MARKEDVIDEO'.
There are 0 rows in 1 pages for object 'MARKEDVIDEO'.
DBCC results for 'BUILDING'.
There are 1 rows in 1 pages for object 'BUILDING'.
DBCC results for 'MMOBJS'.
There are 3 rows in 1 pages for object 'MMOBJS'.
DBCC results for 'CARDFORMAT'.
There are 13 rows in 1 pages for object 'CARDFORMAT'.
DBCC results for 'SEGMENT_EMAIL_LINK'.
There are 0 rows in 0 pages for object 'SEGMENT_EMAIL_LINK'.
DBCC results for 'EXECFUNCLISTACTION'.
There are 0 rows in 0 pages for object 'EXECFUNCLISTACTION'.
DBCC results for 'ACTION_SCHEDULE'.
There are 1 rows in 1 pages for object 'ACTION_SCHEDULE'.
DBCC results for 'MMOBJTYPS'.
There are 2 rows in 1 pages for object 'MMOBJTYPS'.
DBCC results for 'WRKSTATION'.
There are 2 rows in 1 pages for object 'WRKSTATION'.
DBCC results for 'VISIT_SEARCH'.
There are 2 rows in 1 pages for object 'VISIT_SEARCH'.
DBCC results for 'EXPECTED_TRANSACTION_TIME'.
There are 0 rows in 0 pages for object 'EXPECTED_TRANSACTION_TIME'.
DBCC results for 'MOBILE_ID_CONTROL'.
There are 10 rows in 1 pages for object 'MOBILE_ID_CONTROL'.
DBCC results for 'VISIT_SEARCH_ELEMENT'.
There are 58 rows in 1 pages for object 'VISIT_SEARCH_ELEMENT'.
DBCC results for 'ARCHIVELOCATION'.
There are 2 rows in 1 pages for object 'ARCHIVELOCATION'.
DBCC results for 'ACCOUNT_GROUP'.
There are 0 rows in 0 pages for object 'ACCOUNT_GROUP'.
DBCC results for 'MONDEVLINK'.
There are 22 rows in 2 pages for object 'MONDEVLINK'.
DBCC results for 'CARDFORMAT_SEGMENT_LINK'.
There are 0 rows in 0 pages for object 'CARDFORMAT_SEGMENT_LINK'.
DBCC results for 'EVENTS_VIDEO'.
There are 39 rows in 1 pages for object 'EVENTS_VIDEO'.
DBCC results for 'IPCAMERA_FW_DOWNLOAD_ACTION'.
There are 0 rows in 0 pages for object 'IPCAMERA_FW_DOWNLOAD_ACTION'.
DBCC results for 'ACCESSGRP'.
There are 0 rows in 0 pages for object 'ACCESSGRP'.
DBCC results for 'BADGE_AREA_LOCATION'.
There are 0 rows in 0 pages for object 'BADGE_AREA_LOCATION'.
DBCC results for 'MONSTATION'.
There are 14 rows in 1 pages for object 'MONSTATION'.
DBCC results for 'CCTVCONTROL'.
There are 0 rows in 0 pages for object 'CCTVCONTROL'.
DBCC results for 'IPCAMERA_FW_DOWNLOAD_CAMERA'.
There are 0 rows in 0 pages for object 'IPCAMERA_FW_DOWNLOAD_CAMERA'.
DBCC results for 'ACCESSLVL'.
There are 0 rows in 0 pages for object 'ACCESSLVL'.
DBCC results for 'MUSTER_ZONE_SAFE_LOCATIONS'.
There are 0 rows in 0 pages for object 'MUSTER_ZONE_SAFE_LOCATIONS'.
DBCC results for 'MONZONE'.
There are 1 rows in 1 pages for object 'MONZONE'.
DBCC results for 'DDCONNECT'.
There are 1 rows in 1 pages for object 'DDCONNECT'.
DBCC results for 'LNL_QUEUE'.
There are 0 rows in 0 pages for object 'LNL_QUEUE'.
DBCC results for 'ACCESSPANE'.
There are 23 rows in 2 pages for object 'ACCESSPANE'.
DBCC results for 'INPUT_EVENT'.
There are 0 rows in 0 pages for object 'INPUT_EVENT'.
DBCC results for 'PANELTYPE'.
There are 60 rows in 1 pages for object 'PANELTYPE'.
DBCC results for 'DDFLD'.
There are 128 rows in 3 pages for object 'DDFLD'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'AccessControl'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (AccessControl ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Thanks,
Steven Stuart

View 8 Replies View Related

DBCC CHECKDB Inconsistent Errors

Mar 28, 2007

I'm in the process of trying to cutover SLQ 2000 database activity to a newer used server running Windows 2003. All the latest Win & SQL Service Packs through late Feb 2007 have been installed. The server has a Promise Fast Track S150 TX2plus SCSI raid with 2 80 gb drives. I have been using at as database development system for 3 months without any issues.

This morning I restored the latest full backup and 2 intervening transaction log backups. I am the only user on the system today. I ran DBDCC CHECKDB WITH TABLERESULTS 5 times over a 45 minute period and received 5 different results!

Run 1 - No Error

Run 2 - Following Errors:

2511162Table error: Object ID 754101727, Index ID 0. Keys out of order on page (1:631938), slots 40 and 41.repair_rebuild

8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'DatabaseEventLog' (object ID 754101727).

8928161Object ID 1218103380, index ID 255: Page (1:373888) could not be processed. See other errors for details.repair_allow_data_loss

8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'WeatherTransaction' (object ID 1218103380).

Run 3 - Following Errors:

2511162Table error: Object ID 754101727, Index ID 0. Keys out of order on page (1:631938), slots 40 and 41.repair_rebuild

8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'DatabaseEventLog' (object ID 754101727).

8928161Object ID 1218103380, index ID 255: Page (1:373888) could not be processed. See other errors for details.repair_allow_data_loss

8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'WeatherTransaction' (object ID 1218103380).

Run 4 - Following Errors:

2511162Table error: Object ID 754101727, Index ID 0. Keys out of order on page (1:631938), slots 40 and 41.repair_rebuild

8990101CHECKDB found 0 allocation errors and 1 consistency errors in table 'DatabaseEventLog' (object ID 754101727).

8928161Object ID 1218103380, index ID 255: Page (1:373888) could not be processed. See other errors for details.repair_allow_data_loss

894116102Table error: Object ID 1218103380, index ID 255, page (1:373888). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 8, offset 0x2 is invalid.repair_allow_data_loss

894216101Table error: Object ID 1218103380, index ID 255, page (1:373888). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x8 overlaps with the prior row.repair_allow_data_loss

8990101CHECKDB found 0 allocation errors and 3 consistency errors in table 'WeatherTransaction' (object ID 1218103380).

Run 5 - No Error!

I ran several of the obligatory CHKDSK and had no errors:

c:>chkdsk
The type of the file system is NTFS.

WARNING! F parameter not specified.
Running CHKDSK in read-only mode.

CHKDSK is verifying files (stage 1 of 3)...
File verification completed.
CHKDSK is verifying indexes (stage 2 of 3)...
Index verification completed.
CHKDSK is verifying security descriptors (stage 3 of 3)...
Security descriptor verification completed.

78116030 KB total disk space.
45291176 KB in 33231 files.
10496 KB in 3135 indexes.
0 KB in bad sectors.
121086 KB in use by the system.
65536 KB occupied by the log file.
32693272 KB available on disk.

4096 bytes in each allocation unit.
19529007 total allocation units on disk.
8173318 allocation units available on disk.

Are these DBDCC CHECKDB WTIH TABLERESULTS differences normal or is this a bug or hardware issue? Any advice you can offer would be appreciated.

Thanks! Brad

View 10 Replies View Related

DBCC CHECKDB - Consistency Errors

Apr 27, 2008

Hello All,

After restoring the SQL Server 2000 user database backup into one of the SQL Server 2000 instances I get database consistency errors. I restored this database on this particular server a several times already and every time the consistency errors were detected by dbcc checkdb; however the errors are not consistent - different types of errors, different tables and indexes are affected. I restored the same database backup into a different server and ran dbcc checkdb over it - no errors occurred. Something causes corruption in the database on one particular server. Here are the initial errors:

DBCC results for 'tTREE_COMPONENTS'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1467308437, index ID 0: Page (1:251481) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1467308437, index ID 0, page (1:251481), row 44. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 87 and 57.
There are 663 rows in 16 pages for object 'tTREE_COMPONENTS'.

DBCC results for 'tACCUMULATORS'.
There are 10234724 rows in 97149 pages for object 'tACCUMULATORS'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'tACCUMULATORS' (object ID 1467308437).

DBCC results for 'WATSTARTDATETP'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1905493917, index ID 4: Page (3:224866) could not be processed. See other errors for details.

Server: Msg 8941, Level 16, State 1, Line 1
Table error: Object ID 1905493917, index ID 4, page (3:224866). Test (sorted .offset >= PAGEHEADSIZE) failed. Slot 159, offset 0x1 is invalid.

Server: Msg 8942, Level 16, State 1, Line 1
Table error: Object ID 1905493917, index ID 4, page (3:224866). Test (sorted.offset >= max) failed. Slot 0, offset 0x9f overlaps with the prior row.
There are 4 rows in 1 pages for object 'WATSTARTDATETP'.

DBCC results for 'ACCRUALTRAN'.
There are 5919148 rows in 150538 pages for object 'ACCRUALTRAN'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'ACCRUALTRAN' (object ID 1905493917).

If you could please take a look at the errors and give me your thoughts on what could be the cause for the errors I would greatly appreciate it.

Thank you in advance,

Yulia

View 5 Replies View Related

DBCC CheckDb Latch Errors

Dec 6, 2007

Hi,

we''re currently performing a dry run of migrating some large (100GB+) SQL Server 2000 databases from a SQL 2000 cluster onto a new 2005 mirrorred database pair. The new configuration has completely separate database servers and a new dedicated SAN.

Upon restoring our largest database we are seeing the following errors recorded in the log after setting up mirroring and then trying to run DBCC CHECKDB:

"Unable to read and latch page (1:1323852) with latch type SH. 21(The device is not ready.) failed."

We are currently investigating the SAN hardware logs to determine if this might be a physical issue as it would seem to indicate, however has anyone any experience of this or insight into what may cause this error?

Thanks in advance!

View 3 Replies View Related

HDD Errors After Running DBCC Checkdb

Jan 22, 2008

Hi everybody,

I have a very strange problem. I have installed MS WS2003 SP2 and MS SQL 9.0.3054 SP2.
I have database dbTraceIT with data file on D drive and log file on E drive. If I run T-SQL command:

use dbTraceIT
go
dbcc checkdb
or Integration Services Package (task: Check Database Integrity Task, developed with MS VS)

this comand/or task has generated the hard disk errors on D drive. The chkdsk tool reports errors when hdd index verification has been completed. After hdd errors�� repairing, if I run checkdb T-sql command the situation is repeated again.
Question: is it a bug or something different? Do you have similar disk error if you use e.g. Integration Service Packages (for instance index rebuild or whatever)?

Regards,
Dariusz

PS
Steps to reproduce

Find any DB on your MS SQL. Run chkdsk command on hard drive where DB��s data file is stored. Verify that everything is OK.
Run t-sql command
use dbTraceIT
go
dbcc checkdb
3. Run chkdsk again. It should show hdd errors.

View 20 Replies View Related

Recovery :: Automate Notification On DBCC CHECKDB Errors

Jul 7, 2008

I am looking for the best way to get notifications if DBCC CHECKDB indicates an error on a database it checks. So lets say I create a maintenance plan that runs CHECKDB at 2AM for all user databases. What is the best method to get notifications that the command reported issues on one of the databases?

View 7 Replies View Related

Corrupted Table In SQL 2000, DBCC CheckDB Found No Errors

Jan 21, 2008

Hello,

I am facing an issue with a table in my database.

1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad

2) No queries, even queries that would return only 1 record complete execution against that table

3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.

4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.

5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.

6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table

7) I am unable to Drop the Table

8) DBCC CheckAlloc finds 0 allocation errors and 0 consistency errors.

9) DBCC CheckTable on MY_Table returns with: There are 3148 rows in 33 pages for object 'MY_Table' .. no errors are printed.

Can one of the SQL Gurus on this forum please recommend a course of action.

Thanks in advance.

View 1 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

Interesting SQL Injection Reported

May 26, 2008

All of you just read this article
http://www.bloombit.com/Articles/2008/05/ASCII-Encoded-Binary-String-Automated-SQL-Injection.aspx

View 1 Replies View Related

All Sales Reported After Quarter End

Apr 19, 2007

It's been a long time since I've built tough queries and need some help.

I need to report all sales that happened within a quarter but were reported after the quarter end.

Quarters

Q1 - 1/1 thru 3/31
Q2 - 4/1 thru 6/30
Q3 - 7/1 thru 9/30
Q4 - 10/1 thru 12/31

Sample Data

ticketid salespersonid saledate sale_entereddate
1234 bsmith 1/1/2006 2/1/2006
1235 jgarcia 3/31/2006 4/1/2006
1236 bsmith 1/1/2006 2/3/2006
1237 jdoe 6/23/2006 7/1/2006
1238 bsmith 8/5/2006 8/6/2006
1239 bsmith 10/1/2006 1/1/2007

View 4 Replies View Related

Index Reported As Corrupt After Upgrading To 2005

Oct 30, 2006

After upgrading a server from SQL Server 2000 to 2005,
an index was suddenly being reported as corrupt in the SQL Server log
(probably every time an Insert was done). DBCC CHECKDB / CHECKTABLE
reported no errors, with or without the new WITH DATA_PURITY option.

Anyone else experienced something similar?

How can an index be reported as corrupt when DBCC doesn't report it?

Dropping and re-creating the index solved the problem.
I've restored a backup of the database (made before dropping/re-creating
the index) to try repeating the problem, but no success so far.

View 1 Replies View Related

SQL 2012 :: Incorrect Table Size Being Reported

Aug 15, 2014

I have a table that contains 1.6 million rows, and is about 2.6GB in size.One of the columns is ntext and contained some xml.Realistically, I don't need the xml for anything older than about 2 months, however, i'd like to keep some of the data in the other fields.I decided that if I updated the xml to blank, I would see some considerable space savings, however that doesn't appear to be the case.This is the output of sp_spaceused for my table

name rows reserved data index unused
CommitmentsForPosting1660979 2740336 KB 1857104 KB312 KB882920 KB

After I updated the table to remove the xml, the output of sp_spaceused remained the same.My first thought was that it was probably statistics, so I updated statistics for the table, and nothing changed.I then updated statistics for everything in the database, still no change.I then ran DBCC CLEANTABLE for that table. I didn't really expect it to make a difference, and no surprise, it didn't.

The index on the table is a clustered index on just a GUID column.I rebuilt the index and again it still made no difference (that's a bit of a lie - index_size changed by a few hundred KB)my next test was to run 'select * into XXX from YYY' to create a copy of this table with the same data and data types. I also created the same clustered index from the original table onto the new one.If I then run sp_spaceused on this new copy of the table, I see what I expect to see in sp_spaceused - a table using approximately 256MB of space

name rows reserved data index unused
SPS_TEST 1660979 266400 KB 266400 KB 304 KB56 KB

To be honest, this isn't hugely critical, but I'm just curious as to why the original table is still reporting 2.6GB size, when I think it should probably be nearer 256MB.

View 9 Replies View Related

The OLE DB Provider ....reported An Error. Access Denied.

Dec 27, 2007

I'm trying to export excel data to a SQL Server database as:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:DATA_SOURCEData2.xlsx', 'SELECT * FROM [Sheet1$');

I get errors:

Error Message: The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.

Is there any reason for this error message? Thanks.

View 6 Replies View Related

Data Transfer Reported As Succesfull BUT Only One Row Is Ever Transfered!!

Apr 11, 2006

Hi,
I have SQL Server 2005 Developer Edition installed on my laptop. At this time, our servers here are currently running SQL Server 2000 Enterprise edition. When I try to use the DTS import/export wizard to transfer records between two SQL Server 2000 databases, SQL 2005 always reports the transfer as successful! Although when you check the destination table there is only ever 1 record transfered

This has happened every I have attempted, on any tables, are there any fixes to either perfmit the copy of all records or at least report the error condition that prevents records being transfered?

Regards

Colin

View 4 Replies View Related

BULK Insert Failure - OLE DB Provider 'STREAMS' Reported An Error

Nov 1, 1999

Using BULK Insert with a format file I am receiving the following message:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAMS' reported an error. The provider did not give any information about the error.
The statement has been terminated.

I am running SQL Server 7.0 w/ SP1 applied. The same data file and format files work fine if I use bcp.

The data file contains fixed length records.

Any ideas what the problem is?

View 2 Replies View Related

Email Subscription Reported As Successful But Not Arriving In Recipients Inbox.

Jan 24, 2007

I have a report that is sent via email to a list of recipients. When I look at the subscription in 'My Subscriptions' the value in the Status column states that the message was 'sent successfully', however the email does not appear in the inboxes of any of the intended recipents. The report renders OK via the browser and only takes a few seconds to process. The subscription exports the report as an Excel file. The excel file is approx 8MB in size but this is still below the attachment size limit for internal emails within my organisation. The subscription is tied to a shared schedule. Other reports that are tied to the shared schedule are shown as successful in 'My Subscriptions' and also appear in the inboxes of recipients. All email address are correct.

I forgot to mention, the report was successfully received by all recipients until very recently and the report has not been modified since this time.

Has anyone come across this problem before.

Thanks

Mike

View 3 Replies View Related

MSSQL Server 2005 Reported Account Locked Out For User 'sa'

Nov 29, 2006

Greetings,

I receive an error message in event log when i try to connect to the Database Server using ODBC on a client machine. The database server is running on Windows 2003 Server Standard Edition and the client machine is Windows XP Professional. Following is the error message from the event log:

2147467259 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.

What causes the error to occur and how to resolve it?Appreciate for your assistence.

Thanks and regards,

Viknes

View 4 Replies View Related

VFPOLEDB For Linked Server Reported An Error. Access Denied

Jul 8, 2007

Hi Cindy,
After hours (days?) researching this, your name keeps popping up, you must be the GOTO person for VFP. So:

We have a server that runs a VFP application and stores .dbf free tables in a directory shared as F:apps ele.

I am working on an XPPro box running SQL Server Express 2005 using Management Studio Express.

I am logged on as a user with administrator rights for the domain

We would like to be able to query this data and move it to our SQL tables as needed.

Here is what I have:

EXEC sp_addlinkedserver @server = 'tele',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB',
@datasrc = 'F:apps ele',
@provstr = 'VFPOLEDB.1'
GO

SELECT * FROM tele...PROSPECT_DIVU

Here is what I get:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "tele" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "VFPOLEDB" for linked server "tele".

I have tried:

exec sp_addlinkedsrvlogin
@rmtsrvname = 'tele',
@useself = false,
@locallogin = NULL,
@rmtuser = 'admin',
@rmtpassword = NULL
go

Same result.

I have also tried:

EXEC sp_addlinkedserver
'tele2',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'F:apps ele',
NULL,
'dBase IV'
GO

When I run:

select * from tele2...prospect_divu

I get:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2" returned message "The Microsoft Jet database engine could not find the object 'prospect_divu'. Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2". The provider supports the interface, but returns a failure code when it is used.

What would you suggest?

View 4 Replies View Related

SQL Server 2008 :: Failed Task In Maintenance Plan Not Being Reported By Database Mail

Apr 29, 2015

I have inherited a server on which is a maintenance plan with two subplans on different schedules. In each subplan there are Execute T-SQL tasks with scripts for index rebuilds. Each task is set up with a Completion arrow to the next task and a Failure arrow to a Notify Operator Task. I was asked to add a task for index rebuilds to a specific subplan for a specific database, which is what the other tasks also do. I discovered that my task was failing but the others were fine. No notification was sent about my task failing even though the job is marked in MSDB as a failed job. I have sent a test email using the "Send Test Email..." option when right clicking Database Mail in SSMSand I receive an email so I know Database Mail works.

I set up a test job to model the index job that I can't get notifications from. I have two T-SQL tasks that just select the top row from a small table. The first task has a syntax error that I did so it would fail. I have a failure arrow to a Notify Operator Task and a Completion arrow to another T-SQL task with no syntax error which has a Success arrow to a Notify Operator task. As expected, when I execute this job I receive one failure email and one success email.

The only other troubleshooting step I know to try is to add a Notify Operator task before my failing task. That Notify Operator task will hopefully fire to tell me that the previous step was successful. I am not having problems with the other steps so I was just thinking I would try to get the subplan to send me a success email about one of the steps that has been working fine.

View 1 Replies View Related

SQL Server 2008 :: How To Make Sproc Return Errors For Underlying Table Errors

Jul 1, 2015

I recently updated the datatype of a sproc parameter from bit to tinyint. When I executed the sproc with the updated parameters the sproc appeared to succeed and returned "1 row(s) affected" in the console. However, the update triggered by the sproc did not actually work.

The table column was a bit which only allows 0 or 1 and the sproc was passing a value of 2 so the table was rejecting this value. However, the sproc did not return an error and appeared to return success. So is there a way to configure the database or sproc to return an error message when this type of error occurs?

View 1 Replies View Related

Parent Package Reports Failure On Errors, But No Errors In Log

Jul 31, 2006

I have a parent package that calls child packages inside a For Each container. When I debug/run the parent package (from VS), I get the following error message: Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

It appears to be failing while executing the child package. However, the logs (via the "progress" tab) for both the parent package and the child package show no errors other than the one listed above (and that shows in the parent package log). The child package appears to validate completely without error (all components are green and no error messages in the log). I turned on SSIS logging to a text file and see nothing in there either.

If I bump up the MaximumErrorCount in the parent package and in the Execute Package Task that calls the child package to 4 (to go one above the error count indicated in the message above), the whole thing executes sucessfully. I don't want to leave the Max Error Count set like this. Is there something I am missing? For example are there errors that do not get logged by default? I get some warnings, do a certain number of warnings equal an error?

Thanks,

Lee

View 5 Replies View Related

How To Solve 0 Allocation Errors And 1 Consistency Errors In

Apr 20, 2006

Starwin writes "when i execute DBCC CHECKDB, DBCC CHECKCATALOG
I reveived the following error.
how to solve it?

Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -2093955965, index ID 711, page ID (3:2530). The PageId in the page header = (34443:343146507).
. . . .
. . . .

CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1635188736)' (object ID -1635188736).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1600811521)' (object ID -1600811521).

. . . .
. . . .

Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -8748568, index ID 50307, page ID (3:2497). The PageId in the page header = (26707:762626875).
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -7615284, index ID 35836, page ID (3:2534). The PageId in the page heade"

View 1 Replies View Related

Error 7399: OLE DB Provider 'MSDAORA' Reported An Error. OLE DB Error

Feb 18, 2007

My link server was working just fine until friday evening.
It stopped worked over the week end.
with and error Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error .

---my oracle 10g client is working just fine
--TNS names looks fine
---i recreated the link but i am still getting the same error.

I need your help because a lot of jobs are using that link on Monday it is going to be crazzzy.

View 7 Replies View Related