Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I run the report for a few days then its good. but if I try to retrive data for more then a year then I get this error message.

I tried to run DBCC CHECKDB as it says in the error, but after 10 min running a error came up that it can't continue.

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:952663; actual 2668:-1594740640).
It occurred during a read of page (1:952663) in database ID 5 at offset 0x000001d12ae000 in file 'F:\Data\PointOfSale.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.
share|improve this question
    
What do the Windows error logs tell you? –  swasheck Mar 1 '12 at 19:04
    
Perhaps a restore of this database to another server and then running DBCC CHECKDB REPAIR_REBUILD / REPAIR_ALLOW_DATA_LOSS to assess the impact. –  jl01 Mar 1 '12 at 19:21
    
When I backup and restore the problem would not go with the bak? –  Ezi Mar 1 '12 at 20:12
add comment

1 Answer 1

up vote 1 down vote accepted

It looks like the issue is due to data corruption on page 952663 on F:\Data\PointOfSale.mdf.

The error is not due to large data being returned. One of the pages in your result set is corrupt. You can still circumvent the corrupt pages and get back a large result set.

You can do what @jl01 suggests or you can also try a page level restore for page 952663.

share|improve this answer
    
RESTORE PAGE is not allowed with databases that use the simple recovery model. –  Ezi Mar 1 '12 at 20:46
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.