Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

error msg: Could not continue scan with NOLOCK due to data movement. Expand / Collapse
Author
Message
Posted Wednesday, September 05, 2012 8:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 16, 2013 1:13 AM
Points: 24, Visits: 74
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).

Note that what is being backed up is a snapshot of the database.
Pls can any one help!


Post #1354623
Posted Wednesday, September 05, 2012 9:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,077, Visits: 8,919
From this page:

You cannot back up or restore database snapshots.

John
Post #1354645
Posted Wednesday, September 05, 2012 9:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 16, 2013 1:13 AM
Points: 24, Visits: 74
i cannot backup. The backup job fails with that error
Post #1354649
Posted Wednesday, September 05, 2012 9:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,077, Visits: 8,919
Excellent. Always good when the product behaves as documented.

John
Post #1354651
Posted Wednesday, September 05, 2012 9:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 16, 2013 1:13 AM
Points: 24, Visits: 74
Pls how can you help me with that error.
Post #1354654
Posted Wednesday, September 05, 2012 9:19 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:45 PM
Points: 22,524, Visits: 30,284
Is the backup failing on the actual database or on the snapshot? If the snap shot, it is because you can't backup a snapshot database.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1354655
Posted Wednesday, September 05, 2012 9:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 16, 2013 1:13 AM
Points: 24, Visits: 74
its the actual database, but its online
Post #1354661
Posted Wednesday, September 05, 2012 9:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,077, Visits: 8,919
That's interesting - it contradicts what you said in your original post. Never mind - please will you describe how you're doing the backup of your database? If it's with a T-SQL statement, please post the statement.

John
Post #1354671
Posted Wednesday, September 05, 2012 9:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 16, 2013 1:13 AM
Points: 24, Visits: 74
it is a procedure that is called in the backup job

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
@baktyp varchar (20) ---backup type (full or log)

as
declare @backupfilename = @backuplocationpath + '\' + <someformat>

set @dbname = lower@dbname
set @backuplocationpath = @backuplocationpath



---backup the database/log to the specified location
print 'Backing up ' + @dbname + ' to disk: ' + @backuplocationpath

if @baktyp = 'FULL'
backup database @dbname to disk=@backuplocationpath
else
begin
backup log @dbname to disk=@backupfilename
end



------------------------------
all parameters are given.
Post #1354700
Posted Wednesday, September 05, 2012 10:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
What build of SQL Server?

SELECT  SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel;

Have you checked DB integrity by running CHECKDB lately? Are you running any other jobs, e.g. an index maintenance job, while the backup job is running?


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1354725
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse