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.
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.