I sent this to the list Friday, but I'm not sure if it got lost in the =
shuffle...
I ran the checkdb.sql script against my Emerald database and got a huge =
response from the Server, copied below (full of ugly little errors).
Then I recalculated the database. The server said, "This may take =
awhile." Then, two seconds later, it was finished. =20
What should I do now? Is there some way to fix all these errors? The =
database recalculation didn't appear to change the size of the database. =
It's still 25Mb, with 0.49MB space available. Log size is still 70MB =
with 70MB available. The weekly maintenance task still doesn't work, =
and Seagate Backup Exec still doesn't backup the database. For example, =
it says:
----------
4/2/99 3:07:41 PM Backup Exec Error None 57856 N/A NS An error occurred =
while executing the following query: "DBCC NEWALLOC(Emerald)".
OS error message: "".
DBLIB error message: "General SQL Server error: Check messages from the =
SQL Server.".
Server error message: "Extent not within segment: Object 1856009643, =
indid 1 includes extents on allocation page 13312 which is not in =
segment 1."
--------=20
The IEA listserver won't let me send the whole checkdb.sql results file, =
so here are the *juicy* highlights...maybe I should send the whole thing =
as an attachment directly to support@iea-software.com?=20
Thanks for your reply...the database has been acting strange for about a =
week now.
With respect,
Adam
Checking Emerald
Database 'Emerald' is not in single user mode - may find spurious =
allocation problems due to transactions in progress.
***************************************************************
TABLE: Invoices OBJID =3D 1132531068
INDID=3D1 FIRST=3D1160 ROOT=3D1177 DPAGES=3D751 SORT=3D0
Msg 2558, Level 16, State 2
Extent not within segment: Object 1132531068, indid 1 includes extents =
on allocation page 13824 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1132531068, indid 1 includes extents =
on allocation page 14336 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1132531068, indid 1 includes extents =
on allocation page 15616 which is not in segment 1.
etc. etc. etc.
***************************************************************
TABLE: InvoiceItems OBJID =3D 1356531866
INDID=3D1 FIRST=3D1200 ROOT=3D1210 DPAGES=3D569 SORT=3D0
Msg 2558, Level 16, State 2
Extent not within segment: Object 1356531866, indid 1 includes extents =
on allocation page 13568 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1356531866, indid 1 includes extents =
on allocation page 13824 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1356531866, indid 1 includes extents =
on allocation page 14336 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1356531866, indid 1 includes extents =
on allocation page 14848 which is not in segment 1.
etc. etc. etc.
***************************************************************
TABLE: Calls OBJID =3D 1545056540
INDID=3D1 FIRST=3D2680 ROOT=3D2578 DPAGES=3D6606 SORT=3D0
Msg 2558, Level 16, State 2
Extent not within segment: Object 1545056540, indid 1 includes extents =
on allocation page 12800 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1545056540, indid 1 includes extents =
on allocation page 14848 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1545056540, indid 1 includes extents =
on allocation page 15104 which is not in segment 1.
etc. etc. etc.
***************************************************************
TABLE: MasterAccounts OBJID =3D 1856009643
INDID=3D1 FIRST=3D880 ROOT=3D897 DPAGES=3D227 SORT=3D0
Msg 2558, Level 16, State 2
Extent not within segment: Object 1856009643, indid 1 includes extents =
on allocation page 14592 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1856009643, indid 1 includes extents =
on allocation page 17152 which is not in segment 1.
Msg 2558, Level 16, State 2
Extent not within segment: Object 1856009643, indid 1 includes extents =
on allocation page 17408 which is not in segment 1.
etc.etc.etc.
DBCC UPDATEUSAGE: Sysindexes row for Table 'MasterAccounts' =
(IndexId=3D255) updated:
USED Pages: Changed from (944) to (969) pages
RSVD Pages: Changed from (1171) to (1202) pages
DBCC UPDATEUSAGE: Sysindexes row for Table 'MasterAccounts' =
(IndexId=3D5) updated:
USED Pages: Changed from (2) to (18) pages
RSVD Pages: Changed from (8) to (24) pages
(1 row(s) affected)
Updating RATES
(0 row(s) affected)
(1 row(s) affected)
Updating EXTERNALSYSTEMS
(0 row(s) affected)
etc.etc.etc.
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html