------=_NextPart_000_01BC47F3.777F7CC0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
> I would start with a "dbcc CheckDB(Emerald)" and also a "dbcc
> CheckAlloc(Emerald)".
> See if they return any errors.
Dale,
The result of "dbcc CheckDB(Emerald)" are in the attached TXT file, though
the same error I mentioned earlier shows up in it (along with a couple
"corrections").
The result of "dbcc CheckAlloc(Emerald)" is below:
Checking Emerald
Database 'Emerald' is not in single user mode - may find spurious
allocation problems due to transactions in progress.
Msg 2529, Level 16, State 7
Table Corrupt: Page 4053 not found
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
At this point, I am pointing RadiusNT to just a text file on a different
server until I get the db problem resolved. Currently, the db has been
restored from a diskdump done on 4/11/97 3am, which is missing only a day's
worth of invoice creations/payments, new accounts. If I go back to using
the "newest" db, which I manually backed up by turning off SQLServer and
physically copied all the files in /mssql/data and /mssql/backup to another
directory, I will have the day's worth of accounts, etc. and doing a query
in the Calls table won't produce any errors, BUT there's no Calls data for
about 40 of my 48 ports--and these "missing" ports are no longer being
updated in the Calls table, eventhough CallsOnline works.
What should I do??
Josh
> Josh Hillman wrote:
> >
> > Any idea how to deal with this statement from ISQL/w??
> >
> > select calldate, nasport from calls
> > where calldate > "Apr 1 1997"
> >
> > (lots of calls records for ports 20101 - the next line)
> >
> > Apr 11 1997 1:06AM 20105
> > Msg 605, Level 21, State 1
> > Attempt to fetch logical page 4053 in database 'Emerald' belongs to
object
> > '0', not to object 'Calls'.
> > The SQL Server is terminating this process.
> >
> > This is what I get after restoring the latest backup of the Emerald db
from
> > a diskdump that runs everynight at 3am.
> >
> > Incidentally, this seems to coincide with the port problem in the Calls
> > table that I had mentioned in my previous message (pasted below). I
> > restored the db from the dump at 4/11/97 3am AFTER writing the message
> > below.
------=_NextPart_000_01BC47F3.777F7CC0
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 3094. It has =
been corrected to 1.
The number of rows in Sysindexes for this table was 89592. It has been =
corrected to 15.
*** 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 15 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 360 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 588 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 42.
Table has 848 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 605, Level 21, State 1
Attempt to fetch logical page 4053 in database 'Emerald' belongs to =
object '0', not to object 'Calls'.
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 41.
The total number of TEXT/IMAGE pages in this table is 261.
Table has 261 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 328 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_01BC47F3.777F7CC0--