Bad Page ID during simple query

[JBalcerzak]

I'm getting the following error when I try to do a simple query on our database:

I/O error (bad page ID detected during read at offset 0x000001010bc000 in file 'F:\MSSQL\Data\Database.mdf'

Is there any way to fix this, or do I need to dump and rebuild my database?

 

[Dimandja]

In Books Online, read up on DBCC CHECKDB Recommendations. You may be able to get it fixed.

You could also try restarting SQL Server, and see if the problem goes away.

 

[JBalcerzak]

Thanks, I'll give it a try.

 

[mrdenny]

dbcc checkdb will fix this for you. Run dbcc checkdb ({database_name}) and it will tell you which switch is needed to fix the problem. The database will be unavailable while this is running.

Denny

--Anything is possible. All it takes is a little research. (Me)