Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DBCC CHECKDB
- Thread starter umeman
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
A consistency error is usually caused by coruption within the actual mdf or ldf file.
The metadata within the file tells the SQL Server that the data it's looking for is located within block 14:234. However when SQL looks at block 14:234 the data isn't there or it isn't readable. You now have a consistency error.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
The metadata within the file tells the SQL Server that the data it's looking for is located within block 14:234. However when SQL looks at block 14:234 the data isn't there or it isn't readable. You now have a consistency error.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question