August 9, 2011 at 10:03 am
Hello everyone,
There has been a maintenance plan that has ran successfully on several DB's.
When log shipping one of the databases the maintenance plan fails on that database giving the following error:
A database snapshot cannot be created Create file access denied
Even though I do not believe this to be a permission error because none of the checks against other DB's would have been successful I changed the SQLServer Engine and the SQL Agent to run under a domain admin account with access to to all appropriate folders.
Could it be that the log shipping had a lock on the .mdf at the time the maintenance plan was looking to run an integrity check on the database?
Jonathan
August 10, 2011 at 1:25 am
Are you running the command with Tab Lock?
If TABLOCK is specified it will impose lock to have consistency.
Otherwise DBCC CHECKDB uses an internal database snapshot for the transactional consistency to perform these checks. This prevents blocking and concurrency problems when these commands are executed
August 10, 2011 at 7:34 am
The command is not being ran with TABLOCK.
It was successful running up against other databases and also this specific database.
Failed for the first time when I setup log shipping against it.
Before this change there were no failures.
Jonathan
August 10, 2011 at 8:17 am
Long shot but this might be it...
If not then we need to see the full errors and any other errors you might have in the logs.
http://www.sqlskills.com/BLOGS/PAUL/post/Database-snapshots-when-things-go-wrong.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply