ns am having actually an concern when to run queries or save on computer procedures. Every time I operation a query I acquire the following error:

Could not continue scan v NOLOCK because of data movement.

You are watching: Could not continue scan with nolock due to data movement.

If I eliminate the v NOLOCK command, I get a various error:

Msg 824, Level 24, State 2, line 1

SQL Server detect a reasonable consistency-based I/O error: not correct pageid (expected 1:19818941; really 1:19818957). It developed during a read of page (1:19818941) in database id 9 at balance out 0x000025cd37a000 in file "E:\SQLDATA\MSCRM.mdf". Extr messages in the SQL Server error log in or system event log might provide more detail. This is a serious error problem that intimidates database integrity and must be corrected immediately. Finish a complete database consistency examine (DBCC CHECKDB). This error have the right to be resulted in by many factors; for an ext information, check out SQL Server books Online.

What must I do to settle this error?

sql sql-server
improve this concern
edited Jun 2 "13 in ~ 4:35

Michael Liu
46.3k1212 yellow badges107107 silver badges138138 bronze badges
asked Jun 2 "13 at 4:15

2,36599 gold badges4040 silver- badges6464 bronze title
| show 1 much more comment

1 price 1

energetic oldest Votes
First, obviously, try DBCC CHECKDB.

If that cannot solve the issue, you might need to restore from a backup and then manually copy over the most recent changes. Hopefully you have actually been doing nightly backups... ?

boost this answer
reply Jun 2 "13 at 4:59

15.5k44 gold badges3434 silver- badges5858 bronze title
add a comment |

your Answer

Thanks because that contributing response to ridge Overflow!

Please be certain to answer the question. Carry out details and also share your research!

But avoid

Asking because that help, clarification, or responding to various other answers.Making statements based upon opinion; ago them increase with references or an individual experience.

To learn more, view our tips on writing great answers.

See more: Fairy Tail Episode 276 English Dubbed, Episode 276

Draft saved
Draft discarded

Sign increase or log in

sign up making use of Google
sign up making use of Facebook
sign up using Email and Password

Post together a guest

email Required, yet never shown

Post as a guest


Required, but never shown

write-up Your prize Discard

By clicking “Post her Answer”, you agree come our regards to service, privacy policy and also cookie plan

Not the prize you're looking for? Browse various other questions tagged sql sql-server or questioning your very own question.

The Overflow Blog
Featured ~ above Meta
READ UNCOMMITTED and INNER JOIN: can a ask failed?
Improving the performance of one SQL query
SQL Server: obelisk nullability inconsistency
include a tower with a default worth to an currently table in SQL Server
What is "with (nolock)" in SQL Server?
How have the right to I do an update statement with join in SQL Server?
uncover all tables containing column with mentioned name - ms SQL Server
How deserve to I delete utilizing INNER sign up with with SQL Server?
Error article from Eventviewer for SQL Server
SQL Server recognize a logical consistency-based I/O error.torn page It developed during a check out of page
Resumable online Index - sys.dm_db_database_page_allocations error
warm Network questions more hot concerns

inquiry feed
i ordered it to RSS
question feed To subscribe to this RSS feed, copy and also paste this URL into your RSS reader.


ridge Overflow
ridge Exchange Network
site design / logo © 2021 stack Exchange Inc; user contributions licensed under cc by-sa. Rev2021.9.22.40281

Stack Overflow works finest with JavaScript enabled

her privacy

By click “Accept all cookies”, friend agree stack Exchange deserve to store cookies on your device and disclose information in accordance through our Cookie Policy.