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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backups failing scan with nolock error

Author  Topic 

hali14
Starting Member

5 Posts

Posted - 2008-02-07 : 17:00:29
Hi every time I have 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 doe happen and I do have successfull backup but error also and older files are not getting deleted. Any idea guys

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-07 : 21:57:10
Dup post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96996
Go to Top of Page
   

- Advertisement -