Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup 300G DB: Error 601

Status
Not open for further replies.

jluost1

Programmer
Jun 8, 2001
78
US
I have a problem with backing up 300G DB. It is SQL Server 2000, the MDF(50MBs) is in C drive, one NDF(33,000MBs) and one LDF (21G) are in F drive. The index files are in F drive too. The backup mode is "Full".

When I tried to back it up in Enterprise Manager, after 10 minutes of running, I got the following error:

------------------------------------------------------
Microsoft SQL-DMO (ODBC SQL State: 42000)
Error 601: Could not continue scan with NOLOCK due to data movement.
------------------------------------------------------

Then I hit 'OK' and this one pops up

------------------------------------------------------
Microsoft SQL-DMO (ODBC SQL State:HY000)
Attempt to fetch logical page (1:5439) in database 'msdb' belongs to object
'sysdtspackages', not to object 'backupmediafamily'
------------------------------------------------------

Can anyone help me out?

Thanks a million.

 
how are you performing your backups? Through the use of a Maintenance Plan, a Job w/ TSQL commands, manually thru the wizard in Enterprise Manager or a third-party tool?

Thanks

J. Kusch
 
I performed backup from Enterprise Manager: right click on database -> All tasks ->backup database.

Then it took about 10 minutes to get the first Backup Wizard screen.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top