Data Corruption

• Topics

  Started by

  Posts

  Last post

• sysobjects corruption

  i get the following error when selecting: sysobjects: I/O error (torn page) detected during read at…

  UV

  10 replies

  11 years, 9 months ago

  By: Gail Shaw

• Single table corruption: Can I just drop the table instead of DBCC Reair?

  I have a 2tb database with one table that has apparently been corrupted (torn page). Since we only…

  Dimbulbz

  2 replies

  11 years, 10 months ago

  By: Dimbulbz

• Possible to repair or drop one damaged table

  We have a database that was put in 'suspect' mode, it is now in 'emergency' mode; using DBCC CHECKD…

  Ellen-477471

  7 replies

  11 years, 10 months ago

  By: Gail Shaw

• ERROR 823: I/0 error (torn page) detected during read at the offset 0x00000000182e000 in file D:\program files\microsoft\SQL server\MSSQL\data\msdbdata.mdf

  Hi, Pls i'm having the error 'ERROR 823: I/0 error (torn page) detected during read at the offset 0…

  christy.umoren

  1 replies

  11 years, 11 months ago

  By: Gail Shaw

• ERROR 823: I/0 error (torn page) detected during read at the offset 0x00000000182e000 in file D:\program files\microsoft\SQL server\MSSQL\data\msdbdata.mdf

  In our server suddenly we are getting this problem and we couldnt solve this ERROR 823: I/0 error …

  kanagarajkumarv

  5 replies

  11 years, 11 months ago

  By: Gail Shaw

• 601: Could not continue scan with NOLOCK due to Data movement

  SCENARIO 1 Hi, i'm getting the error msg 601: Could not continue scan with NOLOCK due to Data movem…

  christy.umoren

  5 replies

  12 years, 1 month ago

  By: David Webb-CDS

• SQL 7.0 crash and reinstall and now odbc connections wont connect

  A company pulled me in and wanted me to help with their sql server after a raid failure. They retri…

  netadmin 17163

  1 replies

  12 years, 1 month ago

  By: netadmin 17163

• Export DB

  Hi, Can someone please clarify my below doubt I have a database on which 2 tables are corrupted, I …

  devanandiiway

  7 replies

  12 years, 1 month ago

  By: Ant-Green

• Logical consistency error

  Hi, Often am getting logical consistency error in one my production server. Recently i did DBCC wit…

  devanandiiway

  11 replies

  12 years, 2 months ago

  By: devanandiiway

• How to Recover Deleted Rows from sql 2000 Database

  How to Recover Deleted rows from sql 2000 Database using with some period parameter eg: from 01/01…

  kuriakoserobin

  4 replies

  12 years, 3 months ago

  By: johnwebsoft

• MDMP files

  Hi, In one of my production server, am seeing many MDMP files created on Oct 24. I just refreshed m…

  devanandiiway

  13 replies

  12 years, 4 months ago

  By: devanandiiway

• REPAIR_ALLOW_DATA_LOSS not resolving the allocation error

  hello, this is on sql server 2005. it is for a new client. this may be the first time dbcc checkdb …

  inund8ed

  18 replies

  12 years, 6 months ago

  By: karrylopez

• How to repair the table

  when i running this... DBCC CHECKDB('PMSdb') WITH NO_INFOMSGS Server: Msg 8966, Level 16, State 1, …

  slizam

  28 replies

  12 years, 6 months ago

  By: karrylopez

• SQL 7 Server reinstall Need User and DTS Info.

  We have a server running SQL 7 and one of the raid drives failed. In switching the drive, it corru…

  Len Morris-88237

  2 replies

  12 years, 7 months ago

  By: Len Morris-88237

• The header for file"dbname_log.ldf" is not a valid database file header

  Please help me with this problem. SQL 7.0 I copied both ldf and mdf file after shutting down the SQ…

  steve.ahn71

  1 replies

  12 years, 7 months ago

  By: Suresh B.