Asked By Joseph Geretz
02-Nov-08 10:48 PM
I'm having a problem setting up a developer's workstation with SQL Server
(Developer Edition). Here's the behavior I'm seeing:
A couple of days ago we set up a developers workstation. This is a complex
environment consisting of Windows XP Pro SP 2, a number of Server elements
(SQL Server 2000 / 2005, IIS) a number of development tools (Visual Studio
6, Visual Studio 2005) and a number of Office products (2003 and 2007). To
my chagrin, when we installed our production database into the SQL Server
environment via a Restore, we received numerous errors in trying to access
the database via our application. Finally, we tracked this down to database
corruption using DBCC CHECKDB. Strange. This database (a demo database) is
restored to many, many environments with no problem whatesoever. At first I
was incined to chalk this up to a bad environmental setup.
OK, we tore down the entire environment, reimaged back to the base OS and
begain first by installing SQL Server 2000 and SQL Server 2005. Before
proceeding to install any additional software we restored the database into
both SQL Server 2000 and 2005 environments. We ran DBCC CHECKDB and the
databases checked out flawlessly with no errors. We then proceeded to
install all of the adidtional necessary devleopment and productivity
software.
Well, guess what happened after getting all additional software installed.
You got it - DBCC CHECKDB returns the same errors which we were getting two
days ago! I'm at a loss to explain this. The database backup file is the
same physical file which installs flawlessly into dozens of SQL Server 2000
/ 2005 environment. To all appearances the SQL Server environment on this
new machine is identical to the SQL Server environment which is set up on my
personal workstation and which restores this backup file flawlessly with no
problem. I don't even know how to go about diagnosing this problem.
I am including the error lines form the DBCC CHECKDB following my signature.
If you've ever seen this type of problem, or if you have suggestions for how
to go about diagnosing this problem, I'll be grateful for any advice which
you can provide.
Thanks!
Joseph Geretz
--------------------
DBCC CHECKDB:
Server: Msg 8928, Level 16, State 6, Line 1
Object ID 0, index ID 0: Page (1:5929) could not be processed. See other
errors for details.
DBCC results for 'FreedomDEMO'.
CHECKDB found 1 allocation errors and 0 consistency errors not associated
with any single object.
...
DBCC results for 'INTEGRATIONMSGMAP'.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5928) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 2575, Level 16, State 1, Line 1
IAM page (1:5929) is pointed to by the next pointer of IAM page (0:0) object
ID 1993058136 index ID 0 but was not detected in the scan.
Server: Msg 7965, Level 16, State 1, Line 1
Table error: Could not check object ID 1993058136, index ID 0 due to invalid
allocation (IAM) page(s).
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5929) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1993058136, index ID 0, page (1:5929). Test (IS_ON
(BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:5806), slot 1, text ID 4718919680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:5806), slot 2, text ID 4719312896 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:5920), slot 1, text ID 17104896 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:10522), slot 1, text ID 5243011072 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:10542), slot 1, text ID 4849729536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:10542), slot 2, text ID 4849795072 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:10542), slot 3, text ID 4851171328 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1993058136. The text, ntext, or image node at page
(1:10542), slot 4, text ID 4851367936 is not referenced.
There are 0 rows in 0 pages for object 'INTEGRATIONMSGMAP'.
...
DBCC results for 'APPLICATIONINFO'.
There are 0 rows in 0 pages for object 'APPLICATIONINFO'.
CHECKDB found 3 allocation errors and 10 consistency errors in table
'APPLICATIONINFO' (object ID 1993058136).
...
CHECKDB found 4 allocation errors and 10 consistency errors in database
'FreedomDEMO'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKDB (FreedomDEMO ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.