Could not continue scan with NOLOCK due to data movement

Gunslinger1979Gunslinger1979 Posts: 3
edited November 22, 2016 4:32AM in SQL Compare

I am currently testing the SQL Data Compare 12 tool from Redgate. Reading the description it is exactly what i need for our web application with a SQL Server 2012 in the back-end. We once had a very huge live database with historical data. In the end this database was 1,5 TB big and caused performance issues in our web application. Therefore we are only keeping historical data which is half a year old in this table and all data being older should be moved to another database which is not accessible for customers in our local network. Now I have to compare the live historical database (with data maximally half a year old) with the huge historical internal database and synchronize both regularly. I would like to use SQL Data Compare for this but I am just testing the tool in trial mode....and each time I try to compare the two databases I get the messaage:

Could not continue scan with NOLOCK due to data movement.

I closed all other connections to the databases so SQL Data Compare is the only open connection. I also checked integrity of the databases and everything seems to be ok. What can I do?


Sign In or Register to comment.