Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hali14
Starting Member
5 Posts |
 Posted - 2008-02-08 : 13:34:09
|
| Hi Guys,Every time backup job backup the database or I manually backup the database I receive error message [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 601: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement.This is sql 2000 maintainance job or manual backup does same though actually backup of database does happen and I do have successfull backup but error also and older files are not getting deleted and job shows as failed in enterprise manager. Any idea guysSQL SP is 3A and error log error is [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 601: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 21:46:53
|
| Dup post again:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96996 |
 |
|
|
|
|
|
Backups failing scan with nolock error