InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:23:16 GMT20http://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxThank you very much ...--KrishnaFri, 11 Jan 2013 03:03:45 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxPlease check this article: http://support.microsoft.com/kb/2015756Thu, 10 Jan 2013 22:11:28 GMTprettsonshttp://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxHi Gail Shaw,I did restore from healthy backup and it's fine now...Thank you --KrishnaThu, 03 Jan 2013 03:29:00 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxRestore from a clean backup, that's not repairable in any way.Wed, 02 Jan 2013 06:27:41 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxYou are right. Thank you. I miss two lines ..Here is the complete error message...Please let me know if you need any other details........Msg 8946, Level 16, State 12, Line 1Table error: Allocation page (1:145584) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.Msg 8921, Level 16, State 1, Line 1Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 8998, Level 16, State 2, Line 1Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 46 pages from (1:145584) to (1:153671). See other errors for cause.Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page ID (1:145584) contains an incorrect page ID in its page header. The PageId in the page header = (1:70728).Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page ID (1:145584) contains an incorrect page ID in its page header. The PageId in the page header = (1:70728).CHECKDB found 2 allocation errors and 1 consistency errors not associated with any single object.CHECKDB found 2 allocation errors and 1 consistency errors in database 'WSS_Content_HeartyLivesV2'.Thank you,KrishnaWed, 02 Jan 2013 05:26:23 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxYou are right. Thank you. I miss two lines ..Here is the complete error message...Please let me know if you need any other details........Msg 8946, Level 16, State 12, Line 1Table error: Allocation page (1:145584) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.Msg 8921, Level 16, State 1, Line 1Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 8998, Level 16, State 2, Line 1Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 46 pages from (1:145584) to (1:153671). See other errors for cause.Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page ID (1:145584) contains an incorrect page ID in its page header. The PageId in the page header = (1:70728).Msg 8909, Level 16, State 1, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page ID (1:145584) contains an incorrect page ID in its page header. The PageId in the page header = (1:70728).CHECKDB found 2 allocation errors and 1 consistency errors not associated with any single object.CHECKDB found 2 allocation errors and 1 consistency errors in database 'WSS_Content_HeartyLivesV2'.Thank you,KrishnaWed, 02 Jan 2013 05:26:10 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspxPlease post the full and complete, unedited output of that command (you've left out at least one line, possibly more)Wed, 02 Jan 2013 05:11:09 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1401754-2893-1.aspx--Error Number 824DESCRIPTION: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:845407; actual 1:607839). It occurred during a read of page (1:845407) in database ID 46 at offset 0x0000019ccbe000 in file ‘xx.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.--If run this , I am getting below specified error message DBCC CHECKDB ('DBname') WITH NO_INFOMSGS, ALL_ERRORMSGS--Error message:Msg 8946, Level 16, State 12, Line 1Table error: Allocation page (1:145584) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.Msg 8921, Level 16, State 1, Line 1Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 8998, Level 16, State 2, Line 1Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 6 pages from (1:145584) to (1:153671). See other errors for cause.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page (1:145584). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916617 and -4.Msg 8939, Level 16, State 98, Line 1Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page (1:145584). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916617 and -4.Can you suggest me to resolve this please….Can you please let me know if you need any other details….Thank you in Advance…..KrishnaWed, 02 Jan 2013 04:04:59 GMTkrishnaprasad14