December 10, 2010 at 3:28 am
HI Guru's
On one of our server I'm coming across this problem on the sql error log:
(SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:21053; actual 1:21049). It occurred during a read of page (1:21053) in database ID 7 at offset 0x0000000a47a000 in file 'D:\MSSQL\DATA\DatabaseName.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)
I can't run the DBCHECKDB (DataBaseName,repair_fast) it give me the following error mesagge:Msg 8921, Level 16, State 1, Server <server name>, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
*The is space on my tempdb and I dont know how to check for system table consistent..(if anyone can help with that too)
please if need for information let me know,it's the first time I'm coming across this problem,
1.Is my database corrupt?
2.Is harddrive corrupt?
Please help!!thanks
December 10, 2010 at 4:17 am
Your database is corrupt, it's an irreparable corruption, you need to restore from the last good backup.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
The corruption is likely to be a fault somewhere in the IO subsystem. Check logs, run diagnoses, etc.
p.s. Why on earth were you trying to run repair without knowing what was wrong?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2010 at 7:08 am
I tried to to run DBCC CHECKDB,but I was getting the same Error massage as I got when I tried to run repair.
Thanks for your help.I have managed to get a good backup which is missing a weeks with of data, question is possible to retrieve data that is not corrupt from a corrupt Backup.
December 10, 2010 at 7:18 am
Check that the integrity job has been running and included that database. If the integrity job (which just runs CheckDB) had run on that DB after the corruption occurred, it would have logged the same error that you got running checkDB manually.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2010 at 7:36 am
My Intergirty job is failing in almost of the servers that I support with following error:Message
Executed as user: MK\DFTMMSQL01. ... 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:00:00 AM Progress: 2010-12-05 00:00:01.39 Source: {0605B52D-9850-47D4-86F7-DA7FCC8152EB} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2010-12-05 00:00:32.20 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 0% complete End Progress Progress: 2010-12-05 00:00:32.31 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_ActiveSubscriptions] ON [dbo].[Act...".: 1% complete End Progress Progress: 2010-12-05 00:00:32.31 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 2% complete End Progress Progress: 2010-12-05 00:00:32.34 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_Batch] ON [dbo].[Batch] REBUILD PA...".: 2% complete End Progress Progress: 2010-12-05 00:00:32.34 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 3% complete End Progress Progress: 2010-12-05 00:00:32.35 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_Batch_1] ON [dbo].[Batch] REBUILD ...".: 4% complete End Progress Progress: 2010-12-05 00:00:32.35 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 5% complete End Progress Progress: 2010-12-05 00:00:32.36 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_CachePolicyReportID] ON [dbo].[Cac...".: 5% complete End Progress Progress: 2010-12-05 00:00:32.36 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 6% complete End Progress Progress: 2010-12-05 00:00:32.37 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_CachePolicy] ON [dbo].[CachePolicy...".: 7% complete End Progress Progress: 2010-12-05 00:00:32.37 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 8% complete End Progress Progress: 2010-12-05 00:00:32.52 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_Catalog] ON [dbo].[Catalog] REBUIL...".: 8% complete End Progress Progress: 2010-12-05 00:00:32.52 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 9% complete End Progress Progress: 2010-12-05 00:00:32.55 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_Link] ON [dbo].[Catalog] REBUILD P...".: 10% complete End Progress Progress: 2010-12-05 00:00:32.55 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 11% complete End Progress Progress: 2010-12-05 00:00:32.59 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_Parent] ON [dbo].[Catalog] REBUILD...".: 11% complete End Progress Progress: 2010-12-05 00:00:32.59 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 12% complete End Progress Progress: 2010-12-05 00:00:32.62 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_SnapshotDataId] ON [dbo].[Catalog]...".: 13% complete End Progress Progress: 2010-12-05 00:00:32.62 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 14% complete End Progress Progress: 2010-12-05 00:00:32.62 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_Catalog] ON [dbo].[Catalog] REBUIL...".: 14% complete End Progress Progress: 2010-12-05 00:00:32.62 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 15% complete End Progress Progress: 2010-12-05 00:00:32.63 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_ChunkData] ON [dbo].[ChunkData] RE...".: 16% complete End Progress Progress: 2010-12-05 00:00:32.63 Source: Rebuild Index Task Executing query "USE [ReportServer] ".: 17% complete End Progress Progress: 2010-12-05 00:00:32.66 Source: Rebuild Index Task Executin... The package execution fa... The step failed.
Please assist me before another database corruption..
December 10, 2010 at 7:53 am
That's not an integrity job as far as I can see, those are index rebuilds, and there's nothing other than progress messages in what you posted.
Check the maint plan history or get the job to log to a file. If you're concerned about potential corruption run a checkDB on each database manually.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 10, 2010 at 8:00 am
Thanks a million.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply