I'm trying to detach a database and I'm getting this error :
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:234; actual 0:0).
It occurred during a read of page (1:234) in database ID 5 at offset 0x000000001d4000 in file 'D:\Path\MyDB.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. (Microsoft SQL Server, Error: 824)
What is the problem with this database file ? Other DBs are working well, only this one gives me this error.
DBCC CHECKDB
? What did you find in SQL Server Books Online? Often these kinds of problems require restoring from backup; be prepared to do that if necessary. – Mike Sherrill 'Cat Recall' Feb 15 '11 at 12:31