Hi, i keep getting the error msg;
msg 601:Could not continue scan with NOLOCK due to data movement when backing up my production database. My backup file destination is on a separate server(standby server remotely connected) were recovery is to take place on the backup file to keep the standby database in sync with my production database (this is a form of Log shipping).
Pls can anyone help me with error?
it is a backup job that runs the backup procedure
create procedure sp_bakdb
@dbname sysname ---name of the db to be backed up
@backuplocationpath nvarchar(256) ---unc path to location of the backed up database/log files; (linked server location)
@baktyp varchar (20) ---backup type (full or log)
declare @backupfilename = @backuplocationpath + '\' + <someformat>
set @dbname = lower@dbname
set @backuplocationpath = lower@backuplocationpath
---backup the database/log to the specified location
print 'Backing up ' + @dbname + ' to disk: ' + @backupfilename
if @baktyp = 'FULL'
backup database @dbname to disk=@backupfilename
backup log @dbname to disk=@backupfilename