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.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-21 : 02:04:03
|
| Hi,i have run a select query on a a database CCHITSAMPLE(database name)select * from EMRINTERFACETRANSLATIONS where ID_VALUE = 588918it is giving a strange exceptionMsg 824, Level 24, State 2, Line 1SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:17870; actual 1:344782). It occurred during a read of page (1:17870) in database ID 13 at offset 0x00000008b9c000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CCHITSAMPLE.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.please help me out giving solution for this. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-08-21 : 03:59:39
|
You have database corruption. Do you have any idea when this started? Do you have a clean backup of this database? How critical is the data in this database?Please run the following on this database and post the full resultsDBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS Also please take a look at this article. [url]http://www.sqlservercentral.com/articles/65804/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
msg 824