Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Consistency Error

Author  Topic 

eldhose
Starting Member

14 Posts

Posted - 2005-08-22 : 07:11:09
Hi

I have execute a script on my SQL Db (script to create indexes and views) and got the following error

Server: Msg 823, Level 24, State 2, Line 1
I/O error (bad page ID) detected during read at offset 0x000000232fe000 in file 'D:\...\filename.mdf'
ODBC: Msg 0, Level 16, STate 1
Communication link failure

DBCC CHECKDB returned

Database '' consistency errors in sysobjects, syscolumns, or systtypes prevent further CHECKDB processing..........

dbcc checktable ('syscolumns') returned

Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID 0, page ID (1:86382). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID 0, page ID (1:86383). The PageId in the page header = (0:0).
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 3, index ID 0: Page (1:86382) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 3, index ID 0: Page (1:86383) could not be processed. See other errors for details.
CHECKTABLE found 0 allocation errors and 2 consistency errors not associated with any single object.
DBCC results for 'syscolumns'.
There are 2059 rows in 133 pages for object 'syscolumns'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'syscolumns' (object ID 3).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (databasename.dbo.syscolumns ).


Please help to solve this issue

Thanks & regards,
Eldho

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-08-22 : 12:46:12
Hi Eldho,

Unfortunately, you will need to restore from a backup. DBCC CHECKDB repair cannot fix errors in system tables. These tables are critical to the operation of the server, and we can't reconstruct them from anywhere else.

If you post the output of the following command, I can take a look at the page and see if anything jumps out at me in terms of root cause. At a high-level, the page ID in the header of the page is incorrect: it has a value of 0.

Have you run memory/hardware diagnostics on this server? Is there anything in the event logs (system or application) that might indicate hardware problems?

DBCC TRACEON (3604)
DBCC PAGE (<your_dbname>, 1, 86382, 2)
DBCC PAGE (<your_dbname>, 1, 86382, 3)
DBCC PAGE (<your_dbname>, 1, 86383, 2)
DBCC PAGE (<your_dbname>, 1, 86383, 3)

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

eldhose
Starting Member

14 Posts

Posted - 2005-08-23 : 03:51:10
Hi
I checked the event log but couldn't find any log shows any hardware problem.

Please find output of the following commands

DBCC TRACEON (3604)
DBCC PAGE (<your_dbname>, 1, 86382, 2)
DBCC PAGE (<your_dbname>, 1, 86382, 3)
DBCC PAGE (<your_dbname>, 1, 86383, 2)
DBCC PAGE (<your_dbname>, 1, 86383, 3)

returned

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

----------------------------------------------------------------------------------------------------------
PAGE: (0:0)
-----------

BUFFER:
-------

BUF @0x00DF71C0
---------------
bpage = 0x19CFE000 bhash = 0x00000000 bpageno = (1:86382)
bdbid = 7 breferences = 1 bstat = 0x809
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x19CFE000
----------------
m_pageId = (0:0) m_headerVersion = 0 m_type = 0
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 0 m_indexId = 0 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 0
m_freeCnt = 0 m_freeData = 0 m_reservedCnt = 0
m_lsn = (0:0:0) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:80880) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED

DATA:
-----

Memory Dump @0x19CFE000
-----------------------
19CFE000: 00000000 00000000 00000000 00000000 ................
19CFE010: 00000000 00000000 00000000 00000000 ................
19CFE020: 00000000 00000000 00000000 00000000 ................
19CFE030: 00000000 00000000 00000000 00000000 ................
19CFE040: 00000000 00000000 00000000 00000000 ................
19CFE050: 00000000 00000000 00000000 00000000 ................
19CFE060: 00000000 00000000 00000000 00000000 ................
19CFE070: 00000000 00000000 00000000 00000000 ................
19CFE080: 00000000 00000000 00000000 00000000 ................
19CFE090: 00000000 00000000 00000000 00000000 ................
19CFE0A0: 00000000 00000000 00000000 00000000 ................
19CFE0B0: 00000000 00000000 00000000 00000000 ................
19CFE0C0: 00000000 00000000 00000000 00000000 ................
19CFE0D0: 00000000 00000000 00000000 00000000 ................
19CFE0E0: 00000000 00000000 00000000 00000000 ................
19CFE0F0: 00000000 00000000 00000000 00000000 ................
19CFE100: 00000000 00000000 00000000 00000000 ................
19CFE110: 00000000 00000000 00000000 00000000 ................
19CFE120: 00000000 00000000 00000000 00000000 ................
19CFE130: 00000000 00000000 00000000 00000000 ................
19CFE140: 00000000 00000000 00000000 00000000 ................
19CFE150: 00000000 00000000 00000000 00000000 ................
19CFE160: 00000000 00000000 00000000 00000000 ................
19CFE170: 00000000 00000000 00000000 00000000 ................
19CFE180: 00000000 00000000 00000000 00000000 ................
19CFE190: 00000000 00000000 00000000 00000000 ................
19CFE1A0: 00000000 00000000 00000000 00000000 ................
19CFE1B0: 00000000 00000000 00000000 00000000 ................
19CFE1C0: 00000000 00000000 00000000 00000000 ................
19CFE1D0: 00000000 00000000 00000000 00000000 ................
19CFE1E0: 00000000 00000000 00000000 00000000 ................
19CFE1F0: 00000000 00000000 00000000 00000000 ................
19CFE200: 00000000 00000000 00000000 00000000 ................
19CFE210: 00000000 00000000 00000000 00000000 ................
19CFE220: 00000000 00000000 00000000 00000000 ................
19CFE230: 00000000 00000000 00000000 00000000 ................
19CFE240: 00000000 00000000 00000000 00000000 ................
19CFE250: 00000000 00000000 00000000 00000000 ................
19CFE260: 00000000 00000000 00000000 00000000 ................
19CFE270: 00000000 00000000 00000000 00000000 ................
19CFE280: 00000000 00000000 00000000 00000000 ................
19CFE290: 00000000 00000000 00000000 00000000 ................
19CFE2A0: 00000000 00000000 00000000 00000000 ................
19CFE2B0: 00000000 00000000 00000000 00000000 ................
19CFE2C0: 00000000 00000000 00000000 00000000 ................
19CFE2D0: 00000000 00000000 00000000 00000000 ................
19CFE2E0: 00000000 00000000 00000000 00000000 ................
19CFE2F0: 00000000 00000000 00000000 00000000 ................
19CFE300: 00000000 00000000 00000000 00000000 ................
19CFE310: 00000000 00000000 00000000 00000000 ................
19CFE320: 00000000 00000000 00000000 00000000 ................
19CFE330: 00000000 00000000 00000000 00000000 ................
19CFE340: 00000000 00000000 00000000 00000000 ................
19CFE350: 00000000 00000000 00000000 00000000 ................
19CFE360: 00000000 00000000 00000000 00000000 ................
19CFE370: 00000000 00000000 00000000 00000000 ................
19CFE380: 00000000 00000000 00000000 00000000 ................
19CFE390: 00000000 00000000 00000000 00000000 ................
19CFE3A0: 00000000 00000000 00000000 00000000 ................
19CFE3B0: 00000000 00000000 00000000 00000000 ................
19CFE3C0: 00000000 00000000 00000000 00000000 ................
19CFE3D0: 00000000 00000000 00000000 00000000 ................
19CFE3E0: 00000000 00000000 00000000 00000000 ................
19CFE3F0: 00000000 00000000 00000000 00000000 ................
19CFE400: 00000000 00000000 00000000 00000000 ................
19CFE410: 00000000 00000000 00000000 00000000 ................
19CFE420: 00000000 00000000 00000000 00000000 ................
19CFE430: 00000000 00000000 00000000 00000000 ................
19CFE440: 00000000 00000000 00000000 00000000 ................
19CFE450: 00000000 00000000 00000000 00000000 ................
19CFE460: 00000000 00000000 00000000 00000000 ................
19CFE470: 00000000 00000000 00000000 00000000 ................
19CFE480: 00000000 00000000 00000000 00000000 ................
19CFE490: 00000000 00000000 00000000 00000000 ................
19CFE4A0: 00000000 00000000 00000000 00000000 ................
19CFE4B0: 00000000 00000000 00000000 00000000 ................
19CFE4C0: 00000000 00000000 00000000 00000000 ................
19CFE4D0: 00000000 00000000 00000000 00000000 ................
19CFE4E0: 00000000 00000000 00000000 00000000 ................
19CFE4F0: 00000000 00000000 00000000 00000000 ................
19CFE500: 00000000 00000000 00000000 00000000 ................
19CFE510: 00000000 00000000 00000000 00000000 ................
19CFE520: 00000000 00000000 00000000 00000000 ................
19CFE530: 00000000 00000000 00000000 00000000 ................
19CFE540: 00000000 00000000 00000000 00000000 ................
19CFE550: 00000000 00000000 00000000 00000000 ................
19CFE560: 00000000 00000000 00000000 00000000 ................
19CFE570: 00000000 00000000 00000000 00000000 ................
19CFE580: 00000000 00000000 00000000 00000000 ................
19CFE590: 00000000 00000000 00000000 00000000 ................
19CFE5A0: 00000000 00000000 00000000 00000000 ................
19CFE5B0: 00000000 00000000 00000000 00000000 ................
19CFE5C0: 00000000 00000000 00000000 00000000 ................
19CFE5D0: 00000000 00000000 00000000 00000000 ................
19CFE5E0: 00000000 00000000 00000000 00000000 ................
19CFE5F0: 00000000 00000000 00000000 00000000 ................
19CFE600: 00000000 00000000 00000000 00000000 ................
19CFE610: 00000000 00000000 00000000 00000000 ................
19CFE620: 00000000 00000000 00000000 00000000 ................
19CFE630: 00000000 00000000 00000000 00000000 ................
19CFE640: 00000000 00000000 00000000 00000000 ................
19CFE650: 00000000 00000000 00000000 00000000 ................
19CFE660: 00000000 00000000 00000000 00000000 ................
19CFE670: 00000000 00000000 00000000 00000000 ................
19CFE680: 00000000 00000000 00000000 00000000 ................
19CFE690: 00000000 00000000 00000000 00000000 ................
19CFE6A0: 00000000 00000000 00000000 00000000 ................
19CFE6B0: 00000000 00000000 00000000 00000000 ................
19CFE6C0: 00000000 00000000 00000000 00000000 ................
19CFE6D0: 00000000 00000000 00000000 00000000 ................
19CFE6E0: 00000000 00000000 00000000 00000000 ................
19CFE6F0: 00000000 00000000 00000000 00000000 ................
19CFE700: 00000000 00000000 00000000 00000000 ................
19CFE710: 00000000 00000000 00000000 00000000 ................
19CFE720: 00000000 00000000 00000000 00000000 ................
19CFE730: 00000000 00000000 00000000 00000000 ................
19CFE740: 00000000 00000000 00000000 00000000 ................
19CFE750: 00000000 00000000 00000000 00000000 ................
19CFE760: 00000000 00000000 00000000 00000000 ................
19CFE770: 00000000 00000000 00000000 00000000 ................
19CFE780: 00000000 00000000 00000000 00000000 ................
19CFE790: 00000000 00000000 00000000 00000000 ................
19CFE7A0: 00000000 00000000 00000000 00000000 ................
19CFE7B0: 00000000 00000000 00000000 00000000 ................
19CFE7C0: 00000000 00000000 00000000 00000000 ................
19CFE7D0: 00000000 00000000 00000000 00000000 ................
19CFE7E0: 00000000 00000000 00000000 00000000 ................
19CFE7F0: 00000000 00000000 00000000 00000000 ................
19CFE800: 00000000 00000000 00000000 00000000 ................
19CFE810: 00000000 00000000 00000000 00000000 ................
19CFE820: 00000000 00000000 00000000 00000000 ................
19CFE830: 00000000 00000000 00000000 00000000 ................
19CFE840: 00000000 00000000 00000000 00000000 ................
19CFE850: 00000000 00000000 00000000 00000000 ................
19CFE860: 00000000 00000000 00000000 00000000 ................
19CFE870: 00000000 00000000 00000000 00000000 ................
19CFE880: 00000000 00000000 00000000 00000000 ................
19CFE890: 00000000 00000000 00000000 00000000 ................
19CFE8A0: 00000000 00000000 00000000 00000000 ................
19CFE8B0: 00000000 00000000 00000000 00000000 ................
19CFE8C0: 00000000 00000000 00000000 00000000 ................
19CFE8D0: 00000000 00000000 00000000 00000000 ................
19CFE8E0: 00000000 00000000 00000000 00000000 ................
19CFE8F0: 00000000 00000000 00000000 00000000 ................
19CFE900: 00000000 00000000 00000000 00000000 ................
19CFE910: 00000000 00000000 00000000 00000000 ................
19CFE920: 00000000 00000000 00000000 00000000 ................
19CFE930: 00000000 00000000 00000000 00000000 ................
19CFE940: 00000000 00000000 00000000 00000000 ................
19CFE950: 00000000 00000000 00000000 00000000 ................
19CFE960: 00000000 00000000 00000000 00000000 ................
19CFE970: 00000000 00000000 00000000 00000000 ................
19CFE980: 00000000 00000000 00000000 00000000 ................
19CFE990: 00000000 00000000 00000000 00000000 ................
19CFE9A0: 00000000 00000000 00000000 00000000 ................
19CFE9B0: 00000000 00000000 00000000 00000000 ................
19CFE9C0: 00000000 00000000 00000000 00000000 ................
19CFE9D0: 00000000 00000000 00000000 00000000 ................
19CFE9E0: 00000000 00000000 00000000 00000000 ................
19CFE9F0: 00000000 00000000 00000000 00000000 ................
19CFEA00: 00000000 00000000 00000000 00000000 ................
19CFEA10: 00000000 00000000 00000000 00000000 ................
19CFEA20: 00000000 00000000 00000000 00000000 ................
19CFEA30: 00000000 00000000 00000000 00000000 ................
19CFEA40: 00000000 00000000 00000000 00000000 ................
19CFEA50: 00000000 00000000 00000000 00000000 ................
19CFEA60: 00000000 00000000 00000000 00000000 ................
19CFEA70: 00000000 00000000 00000000 00000000 ................
19CFEA80: 00000000 00000000 00000000 00000000 ................
19CFEA90: 00000000 00000000 00000000 00000000 ................
19CFEAA0: 00000000 00000000 00000000 00000000 ................
19CFEAB0: 00000000 00000000 00000000 00000000 ................
19CFEAC0: 00000000 00000000 00000000 00000000 ................
19CFEAD0: 00000000 00000000 00000000 00000000 ................
19CFEAE0: 00000000 00000000 00000000 00000000 ................
19CFEAF0: 00000000 00000000 00000000 00000000 ................
19CFEB00: 00000000 00000000 00000000 00000000 ................
19CFEB10: 00000000 00000000 00000000 00000000 ................
19CFEB20: 00000000 00000000 00000000 00000000 ................
19CFEB30: 00000000 00000000 00000000 00000000 ................
19CFEB40: 00000000 00000000 00000000 00000000 ................
19CFEB50: 00000000 00000000 00000000 00000000 ................
19CFEB60: 00000000 00000000 00000000 00000000 ................
19CFEB70: 00000000 00000000 00000000 00000000 ................
19CFEB80: 00000000 00000000 00000000 00000000 ................
19CFEB90: 00000000 00000000 00000000 00000000 ................
19CFEBA0: 00000000 00000000 00000000 00000000 ................
19CFEBB0: 00000000 00000000 00000000 00000000 ................
19CFEBC0: 00000000 00000000 00000000 00000000 ................
19CFEBD0: 00000000 00000000 00000000 00000000 ................
19CFEBE0: 00000000 00000000 00000000 00000000 ................
19CFEBF0: 00000000 00000000 00000000 00000000 ................
19CFEC00: 00000000 00000000 00000000 00000000 ................
19CFEC10: 00000000 00000000 00000000 00000000 ................
19CFEC20: 00000000 00000000 00000000 00000000 ................
19CFEC30: 00000000 00000000 00000000 00000000 ................
19CFEC40: 00000000 00000000 00000000 00000000 ................
19CFEC50: 00000000 00000000 00000000 00000000 ................
19CFEC60: 00000000 00000000 00000000 00000000 ................
19CFEC70: 00000000 00000000 00000000 00000000 ................
19CFEC80: 00000000 00000000 00000000 00000000 ................
19CFEC90: 00000000 00000000 00000000 00000000 ................
19CFECA0: 00000000 00000000 00000000 00000000 ................
19CFECB0: 00000000 00000000 00000000 00000000 ................
19CFECC0: 00000000 00000000 00000000 00000000 ................
19CFECD0: 00000000 00000000 00000000 00000000 ................
19CFECE0: 00000000 00000000 00000000 00000000 ................
19CFECF0: 00000000 00000000 00000000 00000000 ................
19CFED00: 00000000 00000000 00000000 00000000 ................
19CFED10: 00000000 00000000 00000000 00000000 ................
19CFED20: 00000000 00000000 00000000 00000000 ................
19CFED30: 00000000 00000000 00000000 00000000 ................
19CFED40: 00000000 00000000 00000000 00000000 ................
19CFED50: 00000000 00000000 00000000 00000000 ................
19CFED60: 00000000 00000000 00000000 00000000 ................
19CFED70: 00000000 00000000 00000000 00000000 ................
19CFED80: 00000000 00000000 00000000 00000000 ................
19CFED90: 00000000 00000000 00000000 00000000 ................
19CFEDA0: 00000000 00000000 00000000 00000000 ................
19CFEDB0: 00000000 00000000 00000000 00000000 ................
19CFEDC0: 00000000 00000000 00000000 00000000 ................
19CFEDD0: 00000000 00000000 00000000 00000000 ................
19CFEDE0: 00000000 00000000 00000000 00000000 ................
19CFEDF0: 00000000 00000000 00000000 00000000 ................
19CFEE00: 00000000 00000000 00000000 00000000 ................
19CFEE10: 00000000 00000000 00000000 00000000 ................
19CFEE20: 00000000 00000000 00000000 00000000 ................
19CFEE30: 00000000 00000000 00000000 00000000 ................
19CFEE40: 00000000 00000000 00000000 00000000 ................
19CFEE50: 00000000 00000000 00000000 00000000 ................
19CFEE60: 00000000 00000000 00000000 00000000 ................
19CFEE70: 00000000 00000000 00000000 00000000 ................
19CFEE80: 00000000 00000000 00000000 00000000 ................
19CFEE90: 00000000 00000000 00000000 00000000 ................
19CFEEA0: 00000000 00000000 00000000 00000000 ................
19CFEEB0: 00000000 00000000 00000000 00000000 ................
19CFEEC0: 00000000 00000000 00000000 00000000 ................
19CFEED0: 00000000 00000000 00000000 00000000 ................
19CFEEE0: 00000000 00000000 00000000 00000000 ................
19CFEEF0: 00000000 00000000 00000000 00000000 ................
19CFEF00: 00000000 00000000 00000000 00000000 ................
19CFEF10: 00000000 00000000 00000000 00000000 ................
19CFEF20: 00000000 00000000 00000000 00000000 ................
19CFEF30: 00000000 00000000 00000000 00000000 ................
19CFEF40: 00000000 00000000 00000000 00000000 ................
19CFEF50: 00000000 00000000 00000000 00000000 ................
19CFEF60: 00000000 00000000 00000000 00000000 ................
19CFEF70: 00000000 00000000 00000000 00000000 ................
19CFEF80: 00000000 00000000 00000000 00000000 ................
19CFEF90: 00000000 00000000 00000000 00000000 ................
19CFEFA0: 00000000 00000000 00000000 00000000 ................
19CFEFB0: 00000000 00000000 00000000 00000000 ................
19CFEFC0: 00000000 00000000 00000000 00000000 ................
19CFEFD0: 00000000 00000000 00000000 00000000 ................
19CFEFE0: 00000000 00000000 00000000 00000000 ................
19CFEFF0: 00000000 00000000 00000000 00000000 ................
19CFF000: 00000000 00000000 00000000 00000000 ................
19CFF010: 00000000 00000000 00000000 00000000 ................
19CFF020: 00000000 00000000 00000000 00000000 ................
19CFF030: 00000000 00000000 00000000 00000000 ................
19CFF040: 00000000 00000000 00000000 00000000 ................
19CFF050: 00000000 00000000 00000000 00000000 ................
19CFF060: 00000000 00000000 00000000 00000000 ................
19CFF070: 00000000 00000000 00000000 00000000 ................
19CFF080: 00000000 00000000 00000000 00000000 ................
19CFF090: 00000000 00000000 00000000 00000000 ................
19CFF0A0: 00000000 00000000 00000000 00000000 ................
19CFF0B0: 00000000 00000000 00000000 00000000 ................
19CFF0C0: 00000000 00000000 00000000 00000000 ................
19CFF0D0: 00000000 00000000 00000000 00000000 ................
19CFF0E0: 00000000 00000000 00000000 00000000 ................
19CFF0F0: 00000000 00000000 00000000 00000000 ................
19CFF100: 00000000 00000000 00000000 00000000 ................
19CFF110: 00000000 00000000 00000000 00000000 ................
19CFF120: 00000000 00000000 00000000 00000000 ................
19CFF130: 00000000 00000000 00000000 00000000 ................
19CFF140: 00000000 00000000 00000000 00000000 ................
19CFF150: 00000000 00000000 00000000 00000000 ................
19CFF160: 00000000 00000000 00000000 00000000 ................
19CFF170: 00000000 00000000 00000000 00000000 ................
19CFF180: 00000000 00000000 00000000 00000000 ................
19CFF190: 00000000 00000000 00000000 00000000 ................
19CFF1A0: 00000000 00000000 00000000 00000000 ................
19CFF1B0: 00000000 00000000 00000000 00000000 ................
19CFF1C0: 00000000 00000000 00000000 00000000 ................
19CFF1D0: 00000000 00000000 00000000 00000000 ................
19CFF1E0: 00000000 00000000 00000000 00000000 ................
19CFF1F0: 00000000 00000000 00000000 00000000 ................
19CFF200: 00000000 00000000 00000000 00000000 ................
19CFF210: 00000000 00000000 00000000 00000000 ................
19CFF220: 00000000 00000000 00000000 00000000 ................
19CFF230: 00000000 00000000 00000000 00000000 ................
19CFF240: 00000000 00000000 00000000 00000000 ................
19CFF250: 00000000 00000000 00000000 00000000 ................
19CFF260: 00000000 00000000 00000000 00000000 ................
19CFF270: 00000000 00000000 00000000 00000000 ................
19CFF280: 00000000 00000000 00000000 00000000 ................
19CFF290: 00000000 00000000 00000000 00000000 ................
19CFF2A0: 00000000 00000000 00000000 00000000 ................
19CFF2B0: 00000000 00000000 00000000 00000000 ................
19CFF2C0: 00000000 00000000 00000000 00000000 ................
19CFF2D0: 00000000 00000000 00000000 00000000 ................
19CFF2E0: 00000000 00000000 00000000 00000000 ................
19CFF2F0: 00000000 00000000 00000000 00000000 ................
19CFF300: 00000000 00000000 00000000 00000000 ................
19CFF310: 00000000 00000000 00000000 00000000 ................
19CFF320: 00000000 00000000 00000000 00000000 ................
19CFF330: 00000000 00000000 00000000 00000000 ................
19CFF340: 00000000 00000000 00000000 00000000 ................
19CFF350: 00000000 00000000 00000000 00000000 ................
19CFF360: 00000000 00000000 00000000 00000000 ................
19CFF370: 00000000 00000000 00000000 00000000 ................
19CFF380: 00000000 00000000 00000000 00000000 ................
19CFF390: 00000000 00000000 00000000 00000000 ................
19CFF3A0: 00000000 00000000 00000000 00000000 ................
19CFF3B0: 00000000 00000000 00000000 00000000 ................
19CFF3C0: 00000000 00000000 00000000 00000000 ................
19CFF3D0: 00000000 00000000 00000000 00000000 ................
19CFF3E0: 00000000 00000000 00000000 00000000 ................
19CFF3F0: 00000000 00000000 00000000 00000000 ................
19CFF400: 00000000 00000000 00000000 00000000 ................
19CFF410: 00000000 00000000 00000000 00000000 ................
19CFF420: 00000000 00000000 00000000 00000000 ................
19CFF430: 00000000 00000000 00000000 00000000 ................
19CFF440: 00000000 00000000 00000000 00000000 ................
19CFF450: 00000000 00000000 00000000 00000000 ................
19CFF460: 00000000 00000000 00000000 00000000 ................
19CFF470: 00000000 00000000 00000000 00000000 ................
19CFF480: 00000000 00000000 00000000 00000000 ................
19CFF490: 00000000 00000000 00000000 00000000 ................
19CFF4A0: 00000000 00000000 00000000 00000000 ................
19CFF4B0: 00000000 00000000 00000000 00000000 ................
19CFF4C0: 00000000 00000000 00000000 00000000 ................
19CFF4D0: 00000000 00000000 00000000 00000000 ................
19CFF4E0: 00000000 00000000 00000000 00000000 ................
19CFF4F0: 00000000 00000000 00000000 00000000 ................
19CFF500: 00000000 00000000 00000000 00000000 ................
19CFF510: 00000000 00000000 00000000 00000000 ................
19CFF520: 00000000 00000000 00000000 00000000 ................
19CFF530: 00000000 00000000 00000000 00000000 ................
19CFF540: 00000000 00000000 00000000 00000000 ................
19CFF550: 00000000 00000000 00000000 00000000 ................
19CFF560: 00000000 00000000 00000000 00000000 ................
19CFF570: 00000000 00000000 00000000 00000000 ................
19CFF580: 00000000 00000000 00000000 00000000 ................
19CFF590: 00000000 00000000 00000000 00000000 ................
19CFF5A0: 00000000 00000000 00000000 00000000 ................
19CFF5B0: 00000000 00000000 00000000 00000000 ................
19CFF5C0: 00000000 00000000 00000000 00000000 ................
19CFF5D0: 00000000 00000000 00000000 00000000 ................
19CFF5E0: 00000000 00000000 00000000 00000000 ................
19CFF5F0: 00000000 00000000 00000000 00000000 ................
19CFF600: 00000000 00000000 00000000 00000000 ................
19CFF610: 00000000 00000000 00000000 00000000 ................
19CFF620: 00000000 00000000 00000000 00000000 ................
19CFF630: 00000000 00000000 00000000 00000000 ................
19CFF640: 00000000 00000000 00000000 00000000 ................
19CFF650: 00000000 00000000 00000000 00000000 ................
19CFF660: 00000000 00000000 00000000 00000000 ................
19CFF670: 00000000 00000000 00000000 00000000 ................
19CFF680: 00000000 00000000 00000000 00000000 ................
19CFF690: 00000000 00000000 00000000 00000000 ................
19CFF6A0: 00000000 00000000 00000000 00000000 ................
19CFF6B0: 00000000 00000000 00000000 00000000 ................
19CFF6C0: 00000000 00000000 00000000 00000000 ................
19CFF6D0: 00000000 00000000 00000000 00000000 ................
19CFF6E0: 00000000 00000000 00000000 00000000 ................
19CFF6F0: 00000000 00000000 00000000 00000000 ................
19CFF700: 00000000 00000000 00000000 00000000 ................
19CFF710: 00000000 00000000 00000000 00000000 ................
19CFF720: 00000000 00000000 00000000 00000000 ................
19CFF730: 00000000 00000000 00000000 00000000 ................
19CFF740: 00000000 00000000 00000000 00000000 ................
19CFF750: 00000000 00000000 00000000 00000000 ................
19CFF760: 00000000 00000000 00000000 00000000 ................
19CFF770: 00000000 00000000 00000000 00000000 ................
19CFF780: 00000000 00000000 00000000 00000000 ................
19CFF790: 00000000 00000000 00000000 00000000 ................
19CFF7A0: 00000000 00000000 00000000 00000000 ................
19CFF7B0: 00000000 00000000 00000000 00000000 ................
19CFF7C0: 00000000 00000000 00000000 00000000 ................
19CFF7D0: 00000000 00000000 00000000 00000000 ................
19CFF7E0: 00000000 00000000 00000000 00000000 ................
19CFF7F0: 00000000 00000000 00000000 00000000 ................
19CFF800: 00000000 00000000 00000000 00000000 ................
19CFF810: 00000000 00000000 00000000 00000000 ................
19CFF820: 00000000 00000000 00000000 00000000 ................
19CFF830: 00000000 00000000 00000000 00000000 ................
19CFF840: 00000000 00000000 00000000 00000000 ................
19CFF850: 00000000 00000000 00000000 00000000 ................
19CFF860: 00000000 00000000 00000000 00000000 ................
19CFF870: 00000000 00000000 00000000 00000000 ................
19CFF880: 00000000 00000000 00000000 00000000 ................
19CFF890: 00000000 00000000 00000000 00000000 ................
19CFF8A0: 00000000 00000000 00000000 00000000 ................
19CFF8B0: 00000000 00000000 00000000 00000000 ................
19CFF8C0: 00000000 00000000 00000000 00000000 ................
19CFF8D0: 00000000 00000000 00000000 00000000 ................
19CFF8E0: 00000000 00000000 00000000 00000000 ................
19CFF8F0: 00000000 00000000 00000000 00000000 ................
19CFF900: 00000000 00000000 00000000 00000000 ................
19CFF910: 00000000 00000000 00000000 00000000 ................
19CFF920: 00000000 00000000 00000000 00000000 ................
19CFF930: 00000000 00000000 00000000 00000000 ................
19CFF940: 00000000 00000000 00000000 00000000 ................
19CFF950: 00000000 00000000 00000000 00000000 ................
19CFF960: 00000000 00000000 00000000 00000000 ................
19CFF970: 00000000 00000000 00000000 00000000 ................
19CFF980: 00000000 00000000 00000000 00000000 ................
19CFF990: 00000000 00000000 00000000 00000000 ................
19CFF9A0: 00000000 00000000 00000000 00000000 ................
19CFF9B0: 00000000 00000000 00000000 00000000 ................
19CFF9C0: 00000000 00000000 00000000 00000000 ................
19CFF9D0: 00000000 00000000 00000000 00000000 ................
19CFF9E0: 00000000 00000000 00000000 00000000 ................
19CFF9F0: 00000000 00000000 00000000 00000000 ................
19CFFA00: 00000000 00000000 00000000 00000000 ................
19CFFA10: 00000000 00000000 00000000 00000000 ................
19CFFA20: 00000000 00000000 00000000 00000000 ................
19CFFA30: 00000000 00000000 00000000 00000000 ................
19CFFA40: 00000000 00000000 00000000 00000000 ................
19CFFA50: 00000000 00000000 00000000 00000000 ................
19CFFA60: 00000000 00000000 00000000 00000000 ................
19CFFA70: 00000000 00000000 00000000 00000000 ................
19CFFA80: 00000000 00000000 00000000 00000000 ................
19CFFA90: 00000000 00000000 00000000 00000000 ................
19CFFAA0: 00000000 00000000 00000000 00000000 ................
19CFFAB0: 00000000 00000000 00000000 00000000 ................
19CFFAC0: 00000000 00000000 00000000 00000000 ................
19CFFAD0: 00000000 00000000 00000000 00000000 ................
19CFFAE0: 00000000 00000000 00000000 00000000 ................
19CFFAF0: 00000000 00000000 00000000 00000000 ................
19CFFB00: 00000000 00000000 00000000 00000000 ................
19CFFB10: 00000000 00000000 00000000 00000000 ................
19CFFB20: 00000000 00000000 00000000 00000000 ................
19CFFB30: 00000000 00000000 00000000 00000000 ................
19CFFB40: 00000000 00000000 00000000 00000000 ................
19CFFB50: 00000000 00000000 00000000 00000000 ................
19CFFB60: 00000000 00000000 00000000 00000000 ................
19CFFB70: 00000000 00000000 00000000 00000000 ................
19CFFB80: 00000000 00000000 00000000 00000000 ................
19CFFB90: 00000000 00000000 00000000 00000000 ................
19CFFBA0: 00000000 00000000 00000000 00000000 ................
19CFFBB0: 00000000 00000000 00000000 00000000 ................
19CFFBC0: 00000000 00000000 00000000 00000000 ................
19CFFBD0: 00000000 00000000 00000000 00000000 ................
19CFFBE0: 00000000 00000000 00000000 00000000 ................
19CFFBF0: 00000000 00000000 00000000 00000000 ................
19CFFC00: 00000000 00000000 00000000 00000000 ................
19CFFC10: 00000000 00000000 00000000 00000000 ................
19CFFC20: 00000000 00000000 00000000 00000000 ................
19CFFC30: 00000000 00000000 00000000 00000000 ................
19CFFC40: 00000000 00000000 00000000 00000000 ................
19CFFC50: 00000000 00000000 00000000 00000000 ................
19CFFC60: 00000000 00000000 00000000 00000000 ................
19CFFC70: 00000000 00000000 00000000 00000000 ................
19CFFC80: 00000000 00000000 00000000 00000000 ................
19CFFC90: 00000000 00000000 00000000 00000000 ................
19CFFCA0: 00000000 00000000 00000000 00000000 ................
19CFFCB0: 00000000 00000000 00000000 00000000 ................
19CFFCC0: 00000000 00000000 00000000 00000000 ................
19CFFCD0: 00000000 00000000 00000000 00000000 ................
19CFFCE0: 00000000 00000000 00000000 00000000 ................
19CFFCF0: 00000000 00000000 00000000 00000000 ................
19CFFD00: 00000000 00000000 00000000 00000000 ................
19CFFD10: 00000000 00000000 00000000 00000000 ................
19CFFD20: 00000000 00000000 00000000 00000000 ................
19CFFD30: 00000000 00000000 00000000 00000000 ................
19CFFD40: 00000000 00000000 00000000 00000000 ................
19CFFD50: 00000000 00000000 00000000 00000000 ................
19CFFD60: 00000000 00000000 00000000 00000000 ................
19CFFD70: 00000000 00000000 00000000 00000000 ................
19CFFD80: 00000000 00000000 00000000 00000000 ................
19CFFD90: 00000000 00000000 00000000 00000000 ................
19CFFDA0: 00000000 00000000 00000000 00000000 ................
19CFFDB0: 00000000 00000000 00000000 00000000 ................
19CFFDC0: 00000000 00000000 00000000 00000000 ................
19CFFDD0: 00000000 00000000 00000000 00000000 ................
19CFFDE0: 00000000 00000000 00000000 00000000 ................
19CFFDF0: 00000000 00000000 00000000 00000000 ................
19CFFE00: 00000000 00000000 00000000 00000000 ................
19CFFE10: 00000000 00000000 00000000 00000000 ................
19CFFE20: 00000000 00000000 00000000 00000000 ................
19CFFE30: 00000000 00000000 00000000 00000000 ................
19CFFE40: 00000000 00000000 00000000 00000000 ................
19CFFE50: 00000000 00000000 00000000 00000000 ................
19CFFE60: 00000000 00000000 00000000 00000000 ................
19CFFE70: 00000000 00000000 00000000 00000000 ................
19CFFE80: 00000000 00000000 00000000 00000000 ................
19CFFE90: 00000000 00000000 00000000 00000000 ................
19CFFEA0: 00000000 00000000 00000000 00000000 ................
19CFFEB0: 00000000 00000000 00000000 00000000 ................
19CFFEC0: 00000000 00000000 00000000 00000000 ................
19CFFED0: 00000000 00000000 00000000 00000000 ................
19CFFEE0: 00000000 00000000 00000000 00000000 ................
19CFFEF0: 00000000 00000000 00000000 00000000 ................
19CFFF00: 00000000 00000000 00000000 00000000 ................
19CFFF10: 00000000 00000000 00000000 00000000 ................
19CFFF20: 00000000 00000000 00000000 00000000 ................
19CFFF30: 00000000 00000000 00000000 00000000 ................
19CFFF40: 00000000 00000000 00000000 00000000 ................
19CFFF50: 00000000 00000000 00000000 00000000 ................
19CFFF60: 00000000 00000000 00000000 00000000 ................
19CFFF70: 00000000 00000000 00000000 00000000 ................
19CFFF80: 00000000 00000000 00000000 00000000 ................
19CFFF90: 00000000 00000000 00000000 00000000 ................
19CFFFA0: 00000000 00000000 00000000 00000000 ................
19CFFFB0: 00000000 00000000 00000000 00000000 ................
19CFFFC0: 00000000 00000000 00000000 00000000 ................
19CFFFD0: 00000000 00000000 00000000 00000000 ................
19CFFFE0: 00000000 00000000 00000000 00000000 ................
19CFFFF0: 00000000 00000000 00000000 00000000 ................

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
----------------------------------------------------------------------------------------------


PAGE: (0:0)
-----------

BUFFER:
-------

BUF @0x00DF71C0
---------------
bpage = 0x19CFE000 bhash = 0x00000000 bpageno = (1:86382)
bdbid = 7 breferences = 1 bstat = 0x809
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x19CFE000
----------------
m_pageId = (0:0) m_headerVersion = 0 m_type = 0
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 0 m_indexId = 0 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 0
m_freeCnt = 0 m_freeData = 0 m_reservedCnt = 0
m_lsn = (0:0:0) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:80880) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (0:0)
-----------

BUFFER:
-------

BUF @0x00DF7200
---------------
bpage = 0x19D00000 bhash = 0x00000000 bpageno = (1:86383)
bdbid = 7 breferences = 1 bstat = 0x809
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x19D00000
----------------
m_pageId = (0:0) m_headerVersion = 0 m_type = 0
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 0 m_indexId = 0 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 0
m_freeCnt = 0 m_freeData = 0 m_reservedCnt = 0
m_lsn = (0:0:0) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:80880) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED

DATA:
-----

Memory Dump @0x19D00000
-----------------------
19D00000: 00000000 00000000 00000000 00000000 ................
19D00010: 00000000 00000000 00000000 00000000 ................
19D00020: 00000000 00000000 00000000 00000000 ................
19D00030: 00000000 00000000 00000000 00000000 ................
19D00040: 00000000 00000000 00000000 00000000 ................
19D00050: 00000000 00000000 00000000 00000000 ................
19D00060: 00000000 00000000 00000000 00000000 ................
19D00070: 00000000 00000000 00000000 00000000 ................
19D00080: 00000000 00000000 00000000 00000000 ................
19D00090: 00000000 00000000 00000000 00000000 ................
19D000A0: 00000000 00000000 00000000 00000000 ................
19D000B0: 00000000 00000000 00000000 00000000 ................
19D000C0: 00000000 00000000 00000000 00000000 ................
19D000D0: 00000000 00000000 00000000 00000000 ................
19D000E0: 00000000 00000000 00000000 00000000 ................
19D000F0: 00000000 00000000 00000000 00000000 ................
19D00100: 00000000 00000000 00000000 00000000 ................
19D00110: 00000000 00000000 00000000 00000000 ................
19D00120: 00000000 00000000 00000000 00000000 ................
19D00130: 00000000 00000000 00000000 00000000 ................
19D00140: 00000000 00000000 00000000 00000000 ................
19D00150: 00000000 00000000 00000000 00000000 ................
19D00160: 00000000 00000000 00000000 00000000 ................
19D00170: 00000000 00000000 00000000 00000000 ................
19D00180: 00000000 00000000 00000000 00000000 ................
19D00190: 00000000 00000000 00000000 00000000 ................
19D001A0: 00000000 00000000 00000000 00000000 ................
19D001B0: 00000000 00000000 00000000 00000000 ................
19D001C0: 00000000 00000000 00000000 00000000 ................
19D001D0: 00000000 00000000 00000000 00000000 ................
19D001E0: 00000000 00000000 00000000 00000000 ................
19D001F0: 00000000 00000000 00000000 00000000 ................
19D00200: 00000000 00000000 00000000 00000000 ................
19D00210: 00000000 00000000 00000000 00000000 ................
19D00220: 00000000 00000000 00000000 00000000 ................
19D00230: 00000000 00000000 00000000 00000000 ................
19D00240: 00000000 00000000 00000000 00000000 ................
19D00250: 00000000 00000000 00000000 00000000 ................
19D00260: 00000000 00000000 00000000 00000000 ................
19D00270: 00000000 00000000 00000000 00000000 ................
19D00280: 00000000 00000000 00000000 00000000 ................
19D00290: 00000000 00000000 00000000 00000000 ................
19D002A0: 00000000 00000000 00000000 00000000 ................
19D002B0: 00000000 00000000 00000000 00000000 ................
19D002C0: 00000000 00000000 00000000 00000000 ................
19D002D0: 00000000 00000000 00000000 00000000 ................
19D002E0: 00000000 00000000 00000000 00000000 ................
19D002F0: 00000000 00000000 00000000 00000000 ................
19D00300: 00000000 00000000 00000000 00000000 ................
19D00310: 00000000 00000000 00000000 00000000 ................
19D00320: 00000000 00000000 00000000 00000000 ................
19D00330: 00000000 00000000 00000000 00000000 ................
19D00340: 00000000 00000000 00000000 00000000 ................
19D00350: 00000000 00000000 00000000 00000000 ................
19D00360: 00000000 00000000 00000000 00000000 ................
19D00370: 00000000 00000000 00000000 00000000 ................
19D00380: 00000000 00000000 00000000 00000000 ................
19D00390: 00000000 00000000 00000000 00000000 ................
19D003A0: 00000000 00000000 00000000 00000000 ................
19D003B0: 00000000 00000000 00000000 00000000 ................
19D003C0: 00000000 00000000 00000000 00000000 ................
19D003D0: 00000000 00000000 00000000 00000000 ................
19D003E0: 00000000 00000000 00000000 00000000 ................
19D003F0: 00000000 00000000 00000000 00000000 ................
19D00400: 00000000 00000000 00000000 00000000 ................
19D00410: 00000000 00000000 00000000 00000000 ................
19D00420: 00000000 00000000 00000000 00000000 ................
19D00430: 00000000 00000000 00000000 00000000 ................
19D00440: 00000000 00000000 00000000 00000000 ................
19D00450: 00000000 00000000 00000000 00000000 ................
19D00460: 00000000 00000000 00000000 00000000 ................
19D00470: 00000000 00000000 00000000 00000000 ................
19D00480: 00000000 00000000 00000000 00000000 ................
19D00490: 00000000 00000000 00000000 00000000 ................
19D004A0: 00000000 00000000 00000000 00000000 ................
19D004B0: 00000000 00000000 00000000 00000000 ................
19D004C0: 00000000 00000000 00000000 00000000 ................
19D004D0: 00000000 00000000 00000000 00000000 ................
19D004E0: 00000000 00000000 00000000 00000000 ................
19D004F0: 00000000 00000000 00000000 00000000 ................
19D00500: 00000000 00000000 00000000 00000000 ................
19D00510: 00000000 00000000 00000000 00000000 ................
19D00520: 00000000 00000000 00000000 00000000 ................
19D00530: 00000000 00000000 00000000 00000000 ................
19D00540: 00000000 00000000 00000000 00000000 ................
19D00550: 00000000 00000000 00000000 00000000 ................
19D00560: 00000000 00000000 00000000 00000000 ................
19D00570: 00000000 00000000 00000000 00000000 ................
19D00580: 00000000 00000000 00000000 00000000 ................
19D00590: 00000000 00000000 00000000 00000000 ................
19D005A0: 00000000 00000000 00000000 00000000 ................
19D005B0: 00000000 00000000 00000000 00000000 ................
19D005C0: 00000000 00000000 00000000 00000000 ................
19D005D0: 00000000 00000000 00000000 00000000 ................
19D005E0: 00000000 00000000 00000000 00000000 ................
19D005F0: 00000000 00000000 00000000 00000000 ................
19D00600: 00000000 00000000 00000000 00000000 ................
19D00610: 00000000 00000000 00000000 00000000 ................
19D00620: 00000000 00000000 00000000 00000000 ................
19D00630: 00000000 00000000 00000000 00000000 ................
19D00640: 00000000 00000000 00000000 00000000 ................
19D00650: 00000000 00000000 00000000 00000000 ................
19D00660: 00000000 00000000 00000000 00000000 ................
19D00670: 00000000 00000000 00000000 00000000 ................
19D00680: 00000000 00000000 00000000 00000000 ................
19D00690: 00000000 00000000 00000000 00000000 ................
19D006A0: 00000000 00000000 00000000 00000000 ................
19D006B0: 00000000 00000000 00000000 00000000 ................
19D006C0: 00000000 00000000 00000000 00000000 ................
19D006D0: 00000000 00000000 00000000 00000000 ................
19D006E0: 00000000 00000000 00000000 00000000 ................
19D006F0: 00000000 00000000 00000000 00000000 ................
19D00700: 00000000 00000000 00000000 00000000 ................
19D00710: 00000000 00000000 00000000 00000000 ................
19D00720: 00000000 00000000 00000000 00000000 ................
19D00730: 00000000 00000000 00000000 00000000 ................
19D00740: 00000000 00000000 00000000 00000000 ................
19D00750: 00000000 00000000 00000000 00000000 ................
19D00760: 00000000 00000000 00000000 00000000 ................
19D00770: 00000000 00000000 00000000 00000000 ................
19D00780: 00000000 00000000 00000000 00000000 ................
19D00790: 00000000 00000000 00000000 00000000 ................
19D007A0: 00000000 00000000 00000000 00000000 ................
19D007B0: 00000000 00000000 00000000 00000000 ................
19D007C0: 00000000 00000000 00000000 00000000 ................
19D007D0: 00000000 00000000 00000000 00000000 ................
19D007E0: 00000000 00000000 00000000 00000000 ................
19D007F0: 00000000 00000000 00000000 00000000 ................
19D00800: 00000000 00000000 00000000 00000000 ................
19D00810: 00000000 00000000 00000000 00000000 ................
19D00820: 00000000 00000000 00000000 00000000 ................
19D00830: 00000000 00000000 00000000 00000000 ................
19D00840: 00000000 00000000 00000000 00000000 ................
19D00850: 00000000 00000000 00000000 00000000 ................
19D00860: 00000000 00000000 00000000 00000000 ................
19D00870: 00000000 00000000 00000000 00000000 ................
19D00880: 00000000 00000000 00000000 00000000 ................
19D00890: 00000000 00000000 00000000 00000000 ................
19D008A0: 00000000 00000000 00000000 00000000 ................
19D008B0: 00000000 00000000 00000000 00000000 ................
19D008C0: 00000000 00000000 00000000 00000000 ................
19D008D0: 00000000 00000000 00000000 00000000 ................
19D008E0: 00000000 00000000 00000000 00000000 ................
19D008F0: 00000000 00000000 00000000 00000000 ................
19D00900: 00000000 00000000 00000000 00000000 ................
19D00910: 00000000 00000000 00000000 00000000 ................
19D00920: 00000000 00000000 00000000 00000000 ................
19D00930: 00000000 00000000 00000000 00000000 ................
19D00940: 00000000 00000000 00000000 00000000 ................
19D00950: 00000000 00000000 00000000 00000000 ................
19D00960: 00000000 00000000 00000000 00000000 ................
19D00970: 00000000 00000000 00000000 00000000 ................
19D00980: 00000000 00000000 00000000 00000000 ................
19D00990: 00000000 00000000 00000000 00000000 ................
19D009A0: 00000000 00000000 00000000 00000000 ................
19D009B0: 00000000 00000000 00000000 00000000 ................
19D009C0: 00000000 00000000 00000000 00000000 ................
19D009D0: 00000000 00000000 00000000 00000000 ................
19D009E0: 00000000 00000000 00000000 00000000 ................
19D009F0: 00000000 00000000 00000000 00000000 ................
19D00A00: 00000000 00000000 00000000 00000000 ................
19D00A10: 00000000 00000000 00000000 00000000 ................
19D00A20: 00000000 00000000 00000000 00000000 ................
19D00A30: 00000000 00000000 00000000 00000000 ................
19D00A40: 00000000 00000000 00000000 00000000 ................
19D00A50: 00000000 00000000 00000000 00000000 ................
19D00A60: 00000000 00000000 00000000 00000000 ................
19D00A70: 00000000 00000000 00000000 00000000 ................
19D00A80: 00000000 00000000 00000000 00000000 ................
19D00A90: 00000000 00000000 00000000 00000000 ................
19D00AA0: 00000000 00000000 00000000 00000000 ................
19D00AB0: 00000000 00000000 00000000 00000000 ................
19D00AC0: 00000000 00000000 00000000 00000000 ................
19D00AD0: 00000000 00000000 00000000 00000000 ................
19D00AE0: 00000000 00000000 00000000 00000000 ................
19D00AF0: 00000000 00000000 00000000 00000000 ................
19D00B00: 00000000 00000000 00000000 00000000 ................
19D00B10: 00000000 00000000 00000000 00000000 ................
19D00B20: 00000000 00000000 00000000 00000000 ................
19D00B30: 00000000 00000000 00000000 00000000 ................
19D00B40: 00000000 00000000 00000000 00000000 ................
19D00B50: 00000000 00000000 00000000 00000000 ................
19D00B60: 00000000 00000000 00000000 00000000 ................
19D00B70: 00000000 00000000 00000000 00000000 ................
19D00B80: 00000000 00000000 00000000 00000000 ................
19D00B90: 00000000 00000000 00000000 00000000 ................
19D00BA0: 00000000 00000000 00000000 00000000 ................
19D00BB0: 00000000 00000000 00000000 00000000 ................
19D00BC0: 00000000 00000000 00000000 00000000 ................
19D00BD0: 00000000 00000000 00000000 00000000 ................
19D00BE0: 00000000 00000000 00000000 00000000 ................
19D00BF0: 00000000 00000000 00000000 00000000 ................
19D00C00: 00000000 00000000 00000000 00000000 ................
19D00C10: 00000000 00000000 00000000 00000000 ................
19D00C20: 00000000 00000000 00000000 00000000 ................
19D00C30: 00000000 00000000 00000000 00000000 ................
19D00C40: 00000000 00000000 00000000 00000000 ................
19D00C50: 00000000 00000000 00000000 00000000 ................
19D00C60: 00000000 00000000 00000000 00000000 ................
19D00C70: 00000000 00000000 00000000 00000000 ................
19D00C80: 00000000 00000000 00000000 00000000 ................
19D00C90: 00000000 00000000 00000000 00000000 ................
19D00CA0: 00000000 00000000 00000000 00000000 ................
19D00CB0: 00000000 00000000 00000000 00000000 ................
19D00CC0: 00000000 00000000 00000000 00000000 ................
19D00CD0: 00000000 00000000 00000000 00000000 ................
19D00CE0: 00000000 00000000 00000000 00000000 ................
19D00CF0: 00000000 00000000 00000000 00000000 ................
19D00D00: 00000000 00000000 00000000 00000000 ................
19D00D10: 00000000 00000000 00000000 00000000 ................
19D00D20: 00000000 00000000 00000000 00000000 ................
19D00D30: 00000000 00000000 00000000 00000000 ................
19D00D40: 00000000 00000000 00000000 00000000 ................
19D00D50: 00000000 00000000 00000000 00000000 ................
19D00D60: 00000000 00000000 00000000 00000000 ................
19D00D70: 00000000 00000000 00000000 00000000 ................
19D00D80: 00000000 00000000 00000000 00000000 ................
19D00D90: 00000000 00000000 00000000 00000000 ................
19D00DA0: 00000000 00000000 00000000 00000000 ................
19D00DB0: 00000000 00000000 00000000 00000000 ................
19D00DC0: 00000000 00000000 00000000 00000000 ................
19D00DD0: 00000000 00000000 00000000 00000000 ................
19D00DE0: 00000000 00000000 00000000 00000000 ................
19D00DF0: 00000000 00000000 00000000 00000000 ................
19D00E00: 00000000 00000000 00000000 00000000 ................
19D00E10: 00000000 00000000 00000000 00000000 ................
19D00E20: 00000000 00000000 00000000 00000000 ................
19D00E30: 00000000 00000000 00000000 00000000 ................
19D00E40: 00000000 00000000 00000000 00000000 ................
19D00E50: 00000000 00000000 00000000 00000000 ................
19D00E60: 00000000 00000000 00000000 00000000 ................
19D00E70: 00000000 00000000 00000000 00000000 ................
19D00E80: 00000000 00000000 00000000 00000000 ................
19D00E90: 00000000 00000000 00000000 00000000 ................
19D00EA0: 00000000 00000000 00000000 00000000 ................
19D00EB0: 00000000 00000000 00000000 00000000 ................
19D00EC0: 00000000 00000000 00000000 00000000 ................
19D00ED0: 00000000 00000000 00000000 00000000 ................
19D00EE0: 00000000 00000000 00000000 00000000 ................
19D00EF0: 00000000 00000000 00000000 00000000 ................
19D00F00: 00000000 00000000 00000000 00000000 ................
19D00F10: 00000000 00000000 00000000 00000000 ................
19D00F20: 00000000 00000000 00000000 00000000 ................
19D00F30: 00000000 00000000 00000000 00000000 ................
19D00F40: 00000000 00000000 00000000 00000000 ................
19D00F50: 00000000 00000000 00000000 00000000 ................
19D00F60: 00000000 00000000 00000000 00000000 ................
19D00F70: 00000000 00000000 00000000 00000000 ................
19D00F80: 00000000 00000000 00000000 00000000 ................
19D00F90: 00000000 00000000 00000000 00000000 ................
19D00FA0: 00000000 00000000 00000000 00000000 ................
19D00FB0: 00000000 00000000 00000000 00000000 ................
19D00FC0: 00000000 00000000 00000000 00000000 ................
19D00FD0: 00000000 00000000 00000000 00000000 ................
19D00FE0: 00000000 00000000 00000000 00000000 ................
19D00FF0: 00000000 00000000 00000000 00000000 ................
19D01000: 00000000 00000000 00000000 00000000 ................
19D01010: 00000000 00000000 00000000 00000000 ................
19D01020: 00000000 00000000 00000000 00000000 ................
19D01030: 00000000 00000000 00000000 00000000 ................
19D01040: 00000000 00000000 00000000 00000000 ................
19D01050: 00000000 00000000 00000000 00000000 ................
19D01060: 00000000 00000000 00000000 00000000 ................
19D01070: 00000000 00000000 00000000 00000000 ................
19D01080: 00000000 00000000 00000000 00000000 ................
19D01090: 00000000 00000000 00000000 00000000 ................
19D010A0: 00000000 00000000 00000000 00000000 ................
19D010B0: 00000000 00000000 00000000 00000000 ................
19D010C0: 00000000 00000000 00000000 00000000 ................
19D010D0: 00000000 00000000 00000000 00000000 ................
19D010E0: 00000000 00000000 00000000 00000000 ................
19D010F0: 00000000 00000000 00000000 00000000 ................
19D01100: 00000000 00000000 00000000 00000000 ................
19D01110: 00000000 00000000 00000000 00000000 ................
19D01120: 00000000 00000000 00000000 00000000 ................
19D01130: 00000000 00000000 00000000 00000000 ................
19D01140: 00000000 00000000 00000000 00000000 ................
19D01150: 00000000 00000000 00000000 00000000 ................
19D01160: 00000000 00000000 00000000 00000000 ................
19D01170: 00000000 00000000 00000000 00000000 ................
19D01180: 00000000 00000000 00000000 00000000 ................
19D01190: 00000000 00000000 00000000 00000000 ................
19D011A0: 00000000 00000000 00000000 00000000 ................
19D011B0: 00000000 00000000 00000000 00000000 ................
19D011C0: 00000000 00000000 00000000 00000000 ................
19D011D0: 00000000 00000000 00000000 00000000 ................
19D011E0: 00000000 00000000 00000000 00000000 ................
19D011F0: 00000000 00000000 00000000 00000000 ................
19D01200: 00000000 00000000 00000000 00000000 ................
19D01210: 00000000 00000000 00000000 00000000 ................
19D01220: 00000000 00000000 00000000 00000000 ................
19D01230: 00000000 00000000 00000000 00000000 ................
19D01240: 00000000 00000000 00000000 00000000 ................
19D01250: 00000000 00000000 00000000 00000000 ................
19D01260: 00000000 00000000 00000000 00000000 ................
19D01270: 00000000 00000000 00000000 00000000 ................
19D01280: 00000000 00000000 00000000 00000000 ................
19D01290: 00000000 00000000 00000000 00000000 ................
19D012A0: 00000000 00000000 00000000 00000000 ................
19D012B0: 00000000 00000000 00000000 00000000 ................
19D012C0: 00000000 00000000 00000000 00000000 ................
19D012D0: 00000000 00000000 00000000 00000000 ................
19D012E0: 00000000 00000000 00000000 00000000 ................
19D012F0: 00000000 00000000 00000000 00000000 ................
19D01300: 00000000 00000000 00000000 00000000 ................
19D01310: 00000000 00000000 00000000 00000000 ................
19D01320: 00000000 00000000 00000000 00000000 ................
19D01330: 00000000 00000000 00000000 00000000 ................
19D01340: 00000000 00000000 00000000 00000000 ................
19D01350: 00000000 00000000 00000000 00000000 ................
19D01360: 00000000 00000000 00000000 00000000 ................
19D01370: 00000000 00000000 00000000 00000000 ................
19D01380: 00000000 00000000 00000000 00000000 ................
19D01390: 00000000 00000000 00000000 00000000 ................
19D013A0: 00000000 00000000 00000000 00000000 ................
19D013B0: 00000000 00000000 00000000 00000000 ................
19D013C0: 00000000 00000000 00000000 00000000 ................
19D013D0: 00000000 00000000 00000000 00000000 ................
19D013E0: 00000000 00000000 00000000 00000000 ................
19D013F0: 00000000 00000000 00000000 00000000 ................
19D01400: 00000000 00000000 00000000 00000000 ................
19D01410: 00000000 00000000 00000000 00000000 ................
19D01420: 00000000 00000000 00000000 00000000 ................
19D01430: 00000000 00000000 00000000 00000000 ................
19D01440: 00000000 00000000 00000000 00000000 ................
19D01450: 00000000 00000000 00000000 00000000 ................
19D01460: 00000000 00000000 00000000 00000000 ................
19D01470: 00000000 00000000 00000000 00000000 ................
19D01480: 00000000 00000000 00000000 00000000 ................
19D01490: 00000000 00000000 00000000 00000000 ................
19D014A0: 00000000 00000000 00000000 00000000 ................
19D014B0: 00000000 00000000 00000000 00000000 ................
19D014C0: 00000000 00000000 00000000 00000000 ................
19D014D0: 00000000 00000000 00000000 00000000 ................
19D014E0: 00000000 00000000 00000000 00000000 ................
19D014F0: 00000000 00000000 00000000 00000000 ................
19D01500: 00000000 00000000 00000000 00000000 ................
19D01510: 00000000 00000000 00000000 00000000 ................
19D01520: 00000000 00000000 00000000 00000000 ................
19D01530: 00000000 00000000 00000000 00000000 ................
19D01540: 00000000 00000000 00000000 00000000 ................
19D01550: 00000000 00000000 00000000 00000000 ................
19D01560: 00000000 00000000 00000000 00000000 ................
19D01570: 00000000 00000000 00000000 00000000 ................
19D01580: 00000000 00000000 00000000 00000000 ................
19D01590: 00000000 00000000 00000000 00000000 ................
19D015A0: 00000000 00000000 00000000 00000000 ................
19D015B0: 00000000 00000000 00000000 00000000 ................
19D015C0: 00000000 00000000 00000000 00000000 ................
19D015D0: 00000000 00000000 00000000 00000000 ................
19D015E0: 00000000 00000000 00000000 00000000 ................
19D015F0: 00000000 00000000 00000000 00000000 ................
19D01600: 00000000 00000000 00000000 00000000 ................
19D01610: 00000000 00000000 00000000 00000000 ................
19D01620: 00000000 00000000 00000000 00000000 ................
19D01630: 00000000 00000000 00000000 00000000 ................
19D01640: 00000000 00000000 00000000 00000000 ................
19D01650: 00000000 00000000 00000000 00000000 ................
19D01660: 00000000 00000000 00000000 00000000 ................
19D01670: 00000000 00000000 00000000 00000000 ................
19D01680: 00000000 00000000 00000000 00000000 ................
19D01690: 00000000 00000000 00000000 00000000 ................
19D016A0: 00000000 00000000 00000000 00000000 ................
19D016B0: 00000000 00000000 00000000 00000000 ................
19D016C0: 00000000 00000000 00000000 00000000 ................
19D016D0: 00000000 00000000 00000000 00000000 ................
19D016E0: 00000000 00000000 00000000 00000000 ................
19D016F0: 00000000 00000000 00000000 00000000 ................
19D01700: 00000000 00000000 00000000 00000000 ................
19D01710: 00000000 00000000 00000000 00000000 ................
19D01720: 00000000 00000000 00000000 00000000 ................
19D01730: 00000000 00000000 00000000 00000000 ................
19D01740: 00000000 00000000 00000000 00000000 ................
19D01750: 00000000 00000000 00000000 00000000 ................
19D01760: 00000000 00000000 00000000 00000000 ................
19D01770: 00000000 00000000 00000000 00000000 ................
19D01780: 00000000 00000000 00000000 00000000 ................
19D01790: 00000000 00000000 00000000 00000000 ................
19D017A0: 00000000 00000000 00000000 00000000 ................
19D017B0: 00000000 00000000 00000000 00000000 ................
19D017C0: 00000000 00000000 00000000 00000000 ................
19D017D0: 00000000 00000000 00000000 00000000 ................
19D017E0: 00000000 00000000 00000000 00000000 ................
19D017F0: 00000000 00000000 00000000 00000000 ................
19D01800: 00000000 00000000 00000000 00000000 ................
19D01810: 00000000 00000000 00000000 00000000 ................
19D01820: 00000000 00000000 00000000 00000000 ................
19D01830: 00000000 00000000 00000000 00000000 ................
19D01840: 00000000 00000000 00000000 00000000 ................
19D01850: 00000000 00000000 00000000 00000000 ................
19D01860: 00000000 00000000 00000000 00000000 ................
19D01870: 00000000 00000000 00000000 00000000 ................
19D01880: 00000000 00000000 00000000 00000000 ................
19D01890: 00000000 00000000 00000000 00000000 ................
19D018A0: 00000000 00000000 00000000 00000000 ................
19D018B0: 00000000 00000000 00000000 00000000 ................
19D018C0: 00000000 00000000 00000000 00000000 ................
19D018D0: 00000000 00000000 00000000 00000000 ................
19D018E0: 00000000 00000000 00000000 00000000 ................
19D018F0: 00000000 00000000 00000000 00000000 ................
19D01900: 00000000 00000000 00000000 00000000 ................
19D01910: 00000000 00000000 00000000 00000000 ................
19D01920: 00000000 00000000 00000000 00000000 ................
19D01930: 00000000 00000000 00000000 00000000 ................
19D01940: 00000000 00000000 00000000 00000000 ................
19D01950: 00000000 00000000 00000000 00000000 ................
19D01960: 00000000 00000000 00000000 00000000 ................
19D01970: 00000000 00000000 00000000 00000000 ................
19D01980: 00000000 00000000 00000000 00000000 ................
19D01990: 00000000 00000000 00000000 00000000 ................
19D019A0: 00000000 00000000 00000000 00000000 ................
19D019B0: 00000000 00000000 00000000 00000000 ................
19D019C0: 00000000 00000000 00000000 00000000 ................
19D019D0: 00000000 00000000 00000000 00000000 ................
19D019E0: 00000000 00000000 00000000 00000000 ................
19D019F0: 00000000 00000000 00000000 00000000 ................
19D01A00: 00000000 00000000 00000000 00000000 ................
19D01A10: 00000000 00000000 00000000 00000000 ................
19D01A20: 00000000 00000000 00000000 00000000 ................
19D01A30: 00000000 00000000 00000000 00000000 ................
19D01A40: 00000000 00000000 00000000 00000000 ................
19D01A50: 00000000 00000000 00000000 00000000 ................
19D01A60: 00000000 00000000 00000000 00000000 ................
19D01A70: 00000000 00000000 00000000 00000000 ................
19D01A80: 00000000 00000000 00000000 00000000 ................
19D01A90: 00000000 00000000 00000000 00000000 ................
19D01AA0: 00000000 00000000 00000000 00000000 ................
19D01AB0: 00000000 00000000 00000000 00000000 ................
19D01AC0: 00000000 00000000 00000000 00000000 ................
19D01AD0: 00000000 00000000 00000000 00000000 ................
19D01AE0: 00000000 00000000 00000000 00000000 ................
19D01AF0: 00000000 00000000 00000000 00000000 ................
19D01B00: 00000000 00000000 00000000 00000000 ................
19D01B10: 00000000 00000000 00000000 00000000 ................
19D01B20: 00000000 00000000 00000000 00000000 ................
19D01B30: 00000000 00000000 00000000 00000000 ................
19D01B40: 00000000 00000000 00000000 00000000 ................
19D01B50: 00000000 00000000 00000000 00000000 ................
19D01B60: 00000000 00000000 00000000 00000000 ................
19D01B70: 00000000 00000000 00000000 00000000 ................
19D01B80: 00000000 00000000 00000000 00000000 ................
19D01B90: 00000000 00000000 00000000 00000000 ................
19D01BA0: 00000000 00000000 00000000 00000000 ................
19D01BB0: 00000000 00000000 00000000 00000000 ................
19D01BC0: 00000000 00000000 00000000 00000000 ................
19D01BD0: 00000000 00000000 00000000 00000000 ................
19D01BE0: 00000000 00000000 00000000 00000000 ................
19D01BF0: 00000000 00000000 00000000 00000000 ................
19D01C00: 00000000 00000000 00000000 00000000 ................
19D01C10: 00000000 00000000 00000000 00000000 ................
19D01C20: 00000000 00000000 00000000 00000000 ................
19D01C30: 00000000 00000000 00000000 00000000 ................
19D01C40: 00000000 00000000 00000000 00000000 ................
19D01C50: 00000000 00000000 00000000 00000000 ................
19D01C60: 00000000 00000000 00000000 00000000 ................
19D01C70: 00000000 00000000 00000000 00000000 ................
19D01C80: 00000000 00000000 00000000 00000000 ................
19D01C90: 00000000 00000000 00000000 00000000 ................
19D01CA0: 00000000 00000000 00000000 00000000 ................
19D01CB0: 00000000 00000000 00000000 00000000 ................
19D01CC0: 00000000 00000000 00000000 00000000 ................
19D01CD0: 00000000 00000000 00000000 00000000 ................
19D01CE0: 00000000 00000000 00000000 00000000 ................
19D01CF0: 00000000 00000000 00000000 00000000 ................
19D01D00: 00000000 00000000 00000000 00000000 ................
19D01D10: 00000000 00000000 00000000 00000000 ................
19D01D20: 00000000 00000000 00000000 00000000 ................
19D01D30: 00000000 00000000 00000000 00000000 ................
19D01D40: 00000000 00000000 00000000 00000000 ................
19D01D50: 00000000 00000000 00000000 00000000 ................
19D01D60: 00000000 00000000 00000000 00000000 ................
19D01D70: 00000000 00000000 00000000 00000000 ................
19D01D80: 00000000 00000000 00000000 00000000 ................
19D01D90: 00000000 00000000 00000000 00000000 ................
19D01DA0: 00000000 00000000 00000000 00000000 ................
19D01DB0: 00000000 00000000 00000000 00000000 ................
19D01DC0: 00000000 00000000 00000000 00000000 ................
19D01DD0: 00000000 00000000 00000000 00000000 ................
19D01DE0: 00000000 00000000 00000000 00000000 ................
19D01DF0: 00000000 00000000 00000000 00000000 ................
19D01E00: 00000000 00000000 00000000 00000000 ................
19D01E10: 00000000 00000000 00000000 00000000 ................
19D01E20: 00000000 00000000 00000000 00000000 ................
19D01E30: 00000000 00000000 00000000 00000000 ................
19D01E40: 00000000 00000000 00000000 00000000 ................
19D01E50: 00000000 00000000 00000000 00000000 ................
19D01E60: 00000000 00000000 00000000 00000000 ................
19D01E70: 00000000 00000000 00000000 00000000 ................
19D01E80: 00000000 00000000 00000000 00000000 ................
19D01E90: 00000000 00000000 00000000 00000000 ................
19D01EA0: 00000000 00000000 00000000 00000000 ................
19D01EB0: 00000000 00000000 00000000 00000000 ................
19D01EC0: 00000000 00000000 00000000 00000000 ................
19D01ED0: 00000000 00000000 00000000 00000000 ................
19D01EE0: 00000000 00000000 00000000 00000000 ................
19D01EF0: 00000000 00000000 00000000 00000000 ................
19D01F00: 00000000 00000000 00000000 00000000 ................
19D01F10: 00000000 00000000 00000000 00000000 ................
19D01F20: 00000000 00000000 00000000 00000000 ................
19D01F30: 00000000 00000000 00000000 00000000 ................
19D01F40: 00000000 00000000 00000000 00000000 ................
19D01F50: 00000000 00000000 00000000 00000000 ................
19D01F60: 00000000 00000000 00000000 00000000 ................
19D01F70: 00000000 00000000 00000000 00000000 ................
19D01F80: 00000000 00000000 00000000 00000000 ................
19D01F90: 00000000 00000000 00000000 00000000 ................
19D01FA0: 00000000 00000000 00000000 00000000 ................
19D01FB0: 00000000 00000000 00000000 00000000 ................
19D01FC0: 00000000 00000000 00000000 00000000 ................
19D01FD0: 00000000 00000000 00000000 00000000 ................
19D01FE0: 00000000 00000000 00000000 00000000 ................
19D01FF0: 00000000 00000000 00000000 00000000 ................

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (0:0)
-----------

BUFFER:
-------

BUF @0x00DF7200
---------------
bpage = 0x19D00000 bhash = 0x00000000 bpageno = (1:86383)
bdbid = 7 breferences = 1 bstat = 0x809
bspin = 0 bnext = 0x00000000

PAGE HEADER:
------------

Page @0x19D00000
----------------
m_pageId = (0:0) m_headerVersion = 0 m_type = 0
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x0
m_objId = 0 m_indexId = 0 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 0
m_freeCnt = 0 m_freeData = 0 m_reservedCnt = 0
m_lsn = (0:0:0) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 0

Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:80880) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED

DBCC execution completed. If DBCC printed error messages, contact your system administrator.



Thanks & Regards,
Eldho
Go to Top of Page

eldhose
Starting Member

14 Posts

Posted - 2005-08-23 : 09:55:22
Hi,

I restored the DB from the backup , but still getting the same problems. Or do i have to restore an old backup where there was no in consistency on that time.

Regards,
Eldho
Go to Top of Page

ryanston
Microsoft SQL Server Product Team

89 Posts

Posted - 2005-08-23 : 13:46:33
Weird. You have NULL (unformatted) pages linked into the IAM chain for sysindexes. That shouldn't happen, and I can't imagine how hardware could have caused the issue. I've done a search of SQL bugs here, and I don't find anything that would cause your issue. If you are interested in finding root cause, I'd recommend opening up a support case and have them help you look into how this could happen. (I suspect a SQL bug.)

What happens when you select all of the rows from syscolumns using an (INDEX=0) hint? You'll probably get the 823 again, but I'm curious. Are you having runtime problems in the database? That is, are your users complaining of errors when they do their day-to-day work?

To recover, you'll need to either find a database without this corruption present in it, or you'll need to export all of the data from this database into a new one. The problem in syscolumns won't follow the data.

Let me know if you decide to follow up with PSS, and I can help them work through the problem.

Thanks,

----------------------
Ryan Stonecipher
Developer, Microsoft SQL Server Storage Engine, DBCC
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

eldhose
Starting Member

14 Posts

Posted - 2005-08-25 : 08:58:26
Hi Ryan,

Thanks very much for the support. We don't have any run time problem till now. Also Can you please tell me the steps to follow to open a PSS.

Regards,
Eldho.
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-25 : 15:21:08
Go to http://support.microsoft.com and you'll find all the instructions there.

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

eldhose
Starting Member

14 Posts

Posted - 2005-08-28 : 06:19:07
Hi Ryan,

Before going to open a PSS, can you please confirm whether this problem is happened due to some hardware issues?

Regards,
Eldho
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-28 : 10:51:27
quote:
Originally posted by eldhose

Hi Ryan,

Before going to open a PSS, can you please confirm whether this problem is happened due to some hardware issues?

Regards,
Eldho



The only way h/w could have caused this is for an IAM page to be written as zeroes after its been linked into the IAM chain in sysindexes. This is entirely possible but seems very unlikely to me - it smells much more like an allocation bug. Unless you have evidence of h/w problems in the SQL errorlog or Windows event log, you should call PSS to help diagnose the problem.

Thanks

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

eldhose
Starting Member

14 Posts

Posted - 2005-09-05 : 08:51:05
Hi
I am trying to export all the data/objects to a new database , do i have to check 'Use Collation' checkbox. By default it is not selected. Does it makes any difference
Go to Top of Page
   

- Advertisement -