I'm trying to install a Win95/WinNT 4.0 application on a Win2K Pro system. During the installation, Setup gives me an error message saying that the program "Requires Service Pack 3 or above" in order to run -- I assume it is talking about Win NT 4.0 SP3. Unfortunately, the company...
Thanks Paul! In retrospect, I realize I was looking up the alloc page# instead of the extent# -- so no wonder the pagelinks were pointing me to the allocation table! I really appreciate your time in looking into this. I'll definitely be contacting MS Support at this point.
Cheers,
David
By the way, does anyone know if the undocumented procedure: sp_fixindex as described in
http://support.microsoft.com/support/kb/articles/Q106/1/22.asp?LN=EN-US&SD=gn&FR=0&qry=dbcc&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=SQL
is the repair solution I should use?
Thanks,
David
I've finally gotten a chance to check some pagelinks. When I run
dbcc pglinkage (7, 318976,10,2,0,1), I get the following result:
Object ID for pages in this chain = 99.
Page : 318976
Page : 3
pprevpg pointer for page 3 does not point to previous page in chain
as scanned. pprevpg pointer =...
Thanks, Paul. To answer your first question, yes, I did run DBCC NEWALLOC in single-user mode. (Prior to doing that, I got a TON of spurrious error messages.) Now, before I try the dbcc pglinkage trick, could you explain how I will be able to tell if the pointers are good or bad...
When I execute DBCC NEWALLOC on a large (1.5 GB) database, I get an ERROR 2541 message as follows:
Msg 2541, Level 16, State 1
Table Corrupt: object id does not match between extent in allocation page and Sysindexes; check the following extent: alloc pg#=318976 extent#=319088 object id on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.