March 30, 2011 at 4:53 am
Hi
Over the weekend the RAID controller on our network storage failed, this has now been replaced and shares have been restored.
Now i am receiving the following error when my backups run to the network share -
'BackUpTapeFile::OpenMedia: BackupDevice "<<path>>" failed to open. Operating System Error 5(Access is Denied).'
SQL service and SQL agent services are running as Domain Admin, which has full control of the folders on the share.
(SQL server 2005, Server 2008 R2 Enterprise.)
Thank you for any help you can provide.
Regards
March 30, 2011 at 6:02 am
Access Denied is a hard error message to argue with. It's telling you the service account that is running the backup can't access that device. You need to double check that everything is configured as you expected.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 30, 2011 at 6:28 am
Yeah, it is pretty definitive.
I have just gone back and tried to create a .txt file in the folder and am getting the same error, i tried right down to the root of the drive and got the same. I just heard back from the network admin, when the RAID was recreated all the shares and files came back as read only, looks like they can't get it back to read/write without recreating and restoring from backup.
Looks like that is the issue then 🙂
Thank you for your response.
March 30, 2011 at 3:08 pm
Sidenote: you really should not be running SQL Server using a domain admin account. That is going to potentially open you up to some serious security risks.
The recommendation is to use a non privileged domain account and grant appropriate rights as needed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply