[SQLSTATE HY000] (Error 824)

• rohitg1983

  SSC Enthusiast

  Points: 138

  More actions

  August 3, 2008 at 5:41 am

  #188873

  Hi all,

  When I am running check DB ,i am getting the following error.Please advice:

  Executed as user: CPR\sp1adm. DBCC CHECKDB (SP1) started at Jul 26 200

  8 7:00PM with Logfile: C:\Program Files\Microsoft SQL Server\MSSQL.1\

  MSSQL\CCMS_CHECK_DB_HIST_2008.txt [SQLSTATE 01000] (Message 50000) SQ

  L Server detected a logical consistency-based I/O error: incorrect pag

  eid (expected 9:14175548; actual 0:0). It occurred during a read of pa

  ge (9:14175548) in database ID 6 at offset 0x00001b09a78000 in file 'W

  :\SP1DATA8\SP1DATA8.ndf:MSSQL_DBCC6'. 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 (DB

  CC CHECKDB). This error can be caused by many factors; for more inform

  ation, see SQL Server Books Online. [SQLSTATE HY000] (Error 824)

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  August 3, 2008 at 6:40 am

  #852420

  Do a DBCC CHECKDB with repair option.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com