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
share
improve this concern
monitor
edited Jun 2 \"13 in ~ 4:35
\"*\"

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

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

1 price 1


energetic oldest Votes
7
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... ?


re-publishing
boost this answer
monitor
reply Jun 2 \"13 at 4:59
\"*\"

StilesCrisisStilesCrisis
15.5k44 gold badges3434 silver- badges5858 bronze title
1
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
submit

Post together a guest


surname
email Required, yet never shown


Post as a guest


surname
email

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
Linked
0
READ UNCOMMITTED and INNER JOIN: can a ask failed?
1
Improving the performance of one SQL query
associated
1
SQL Server: obelisk nullability inconsistency
2999
include a tower with a default worth to an currently table in SQL Server
643
What is \"with (nolock)\" in SQL Server?
1452
How have the right to I do an update statement with join in SQL Server?
1427
uncover all tables containing column with mentioned name - ms SQL Server
1508
How deserve to I delete utilizing INNER sign up with with SQL Server?
0
Error article from Eventviewer for SQL Server
0
SQL Server recognize a logical consistency-based I/O error.torn page It developed during a check out of page
0
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.


\"*\"

lang-sql
ridge Overflow
assets
agency
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.