------=_NextPart_000_01BC4B10.1017DAD0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
This was sent a couple days ago, but haven't received any
answers/suggestions yet...
Dale,
I ran "dbcc checkdb(Emerald)" and "dbcc checkalloc(Emerald)" and
both came up with errors with the Calls table. The second one produced a
result set of 1.6 megs of text (nearly all error-related about the Calls
table). The response from the first query is attached.
If there's no way to fix this, will dropping the Calls table and recreating
it take care of the problem? If I need to drop the table and recreate it,
I'm guessing that there are probably other tables that will prevent an easy
removal of it, so how do I go about doing this so I don't screw up the
whole db? It's bad enough that I've "lost" nearly all of the data in the
Calls table... Only ports 1-5 and 44-48 are being updated in the Calls
table. All other tables, including the CallsOnline view are working
properly.
In case it makes a difference, the server that SQL resides on, had the
wrong year in it for about 12 hours. The year was set to 96 instead of 97.
At 3am every night, SQL performs a diskdump on Emerald, however because of
the screwy year, that may have caused something to get messed up?? There
are entries in the Calls table for these calls (with the wrong year), but
as with the other calls, calls that took place on ports 6-43 are missing.
SQL 6.5
Emerald 1.1.11
Max 4004 5.0Ai4
NT 4.0 Server SP2 with appropriate hotfixes
Thanks,
Josh Hillman
hillman@talstar.com
------=_NextPart_000_01BC4B10.1017DAD0
Content-Type: application/octet-stream; name="dbcc_checkdb.txt"
Content-Transfer-Encoding: quoted-printable
Content-Description: dbcc_checkdb.txt (Text Document)
Content-Disposition: attachment; filename="dbcc_checkdb.txt"
Checking Emerald
Checking 1
The total number of data pages in this table is 23.
Table has 309 data rows.
Checking 2
The total number of data pages in this table is 11.
Table has 120 data rows.
Checking 3
The total number of data pages in this table is 24.
Table has 583 data rows.
Checking 4
The total number of data pages in this table is 1.
Table has 26 data rows.
Checking 5
The total number of data pages in this table is 134.
Table has 620 data rows.
Checking 6
The total number of data pages in this table is 6.
Table has 144 data rows.
Checking 7
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 8
The total number of data pages in this table is 1.
The number of data pages in Sysindexes for this table was 3099. It has =
been corrected to 1.
The number of rows in Sysindexes for this table was 89759. It has been =
corrected to 30.
*** NOTICE: Space used on the log segment is 0.00 Mbytes, 0.01.
*** NOTICE: Space free on the log segment is 25.60 Mbytes, 99.99.
Table has 30 data rows.
Checking 9
The total number of data pages in this table is 8.
The number of data pages in Sysindexes for this table was 7. It has =
been corrected to 8.
Table has 601 data rows.
Checking 10
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 11
The total number of data pages in this table is 1.
Checking 12
The total number of data pages in this table is 1.
Table has 15 data rows.
Checking 13
The total number of data pages in this table is 1.
Checking 14
The total number of data pages in this table is 2.
Table has 51 data rows.
Checking 15
The total number of data pages in this table is 4.
Table has 232 data rows.
Checking 16
The total number of data pages in this table is 1.
Checking 17
The total number of data pages in this table is 1.
Checking 18
The total number of data pages in this table is 1.
Checking 16003088
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking 64003259
The total number of data pages in this table is 1.
Table has 12 data rows.
Checking 121051467
The total number of data pages in this table is 1.
Checking 144003544
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 172527648
The total number of data pages in this table is 9.
Table has 370 data rows.
Checking 192003715
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 256003943
The total number of data pages in this table is 1.
Checking 304004114
The total number of data pages in this table is 5.
Table has 161 data rows.
Checking 316528161
The total number of data pages in this table is 1.
Checking 345052265
The total number of data pages in this table is 1.
Checking 352004285
The total number of data pages in this table is 3.
Table has 142 data rows.
Checking 409052493
The total number of data pages in this table is 1.
Checking 416004513
The total number of data pages in this table is 1.
Table has 7 data rows.
Checking 421576540
The total number of data pages in this table is 1.
Checking 460528674
The total number of data pages in this table is 1.
Checking 464004684
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 512004855
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking 560005026
The total number of data pages in this table is 1.
Table has 10 data rows.
Checking 565577053
The total number of data pages in this table is 1.
Checking 588529130
The total number of data pages in this table is 1.
Table has 9 data rows.
Checking 608005197
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking 656005368
The total number of data pages in this table is 1.
Table has 8 data rows.
Checking 668529415
The total number of data pages in this table is 1.
Table has 16 data rows.
Checking 704005539
The total number of data pages in this table is 1.
Table has 9 data rows.
Checking 748529700
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking 844530042
The total number of data pages in this table is 1.
Checking 848006052
The total number of data pages in this table is 1.
Table has 9 data rows.
Checking 896006223
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking 940530384
The total number of data pages in this table is 34.
Table has 593 data rows.
Checking 944006394
The total number of data pages in this table is 1.
Checking 992006565
The total number of data pages in this table is 1.
The total number of TEXT/IMAGE pages in this table is 1.
Table has 1 data rows.
Checking 1056006793
The total number of data pages in this table is 3.
Table has 96 data rows.
Checking 1148531125
The total number of data pages in this table is 44.
Table has 854 data rows.
Checking 1228531410
The total number of data pages in this table is 1.
Checking 1248007477
The total number of data pages in this table is 1.
Table has 5 data rows.
Checking 1292531638
The total number of data pages in this table is 1.
Checking 1312007705
The total number of data pages in this table is 1.
Checking 1376007933
Msg 2503, Level 16, State 1
Table Corrupt: Page linkage is not consistent; check the following =
pages: (current page#=3D4053; page# pointing to this page=3D4028; =
previous page# indicated in this page=3D13045)
Checking 1404532037
The total number of data pages in this table is 1.
Checking 1424008104
The total number of data pages in this table is 1.
Checking 1449056198
The total number of data pages in this table is 1.
Checking 1456008218
The total number of data pages in this table is 1.
Checking 1488008332
The total number of data pages in this table is 43.
The total number of TEXT/IMAGE pages in this table is 263.
Table has 263 data rows.
Checking 1497056369
The total number of data pages in this table is 1.
Checking 1561056597
The total number of data pages in this table is 1.
Checking 1628532835
The total number of data pages in this table is 1.
Checking 1653580929
The total number of data pages in this table is 1.
Checking 1657056939
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 1756533291
The total number of data pages in this table is 1.
Checking 1836533576
The total number of data pages in this table is 1.
Table has 39 data rows.
Checking 1872009700
The total number of data pages in this table is 31.
Table has 331 data rows.
Checking 1932533918
The total number of data pages in this table is 1.
Table has 30 data rows.
Checking 1980534089
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking 2028534260
The total number of data pages in this table is 1.
Checking 2108534545
The total number of data pages in this table is 1.
DBCC execution completed. If DBCC printed error messages, see your =
System Administrator.
------=_NextPart_000_01BC4B10.1017DAD0--