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?
improve this concern
edited Jun 2 "13 in ~ 4:35
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 |
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
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
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
i ordered it to RSS
question feed To subscribe to this RSS feed, copy and also paste this URL into your RSS reader.
ridge Exchange Network
site design / logo © 2021 stack Exchange Inc; user contributions licensed under cc by-sa. Rev2021.9.22.40281