SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Network backup issue


Network backup issue

Author
Message
cstrati
cstrati
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 110
SQL server backup issue

When backing up databases on SQLSever2012 to a backup server I am receiving the following error:

failed with the following error: "xp_create_subdir() returned error 5, 'Access is denied.'"
." failed with the following error: "Cannot open backup device


I was able to backup databases to the same location on both SQLServer2008 and 2005 without error so I don't know why I can't backup to the same location on SQLServer2012 as they're setup the same.

When connecting to the server and opening Windows Explorer I'm able navigate to the backup location by entering the network location e.g \\backupdatabase\backup and I can view the folder and create files in this location but when trying to backup to this location I still receive "Access denied" as above.


The account used to login to the server has sysadmin permission and full access to the backup servers folders

The account used to login to The "SQL Server Agent" within services is running under a domain account and has sysadmin permission and full access to the backup folder.

If both the SQLServerAgent account and the account used to login to the server have sysadmin permissions and full permissions to the backup folders then why would access be denied? Please let me know if im missing another step.
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40565 Visits: 32666
I'd double check the security for the account that's running SQL Server. The error you're getting is a security error. It doesn't sound like that account has the correct privileges.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
cstrati
cstrati
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 110
The SQL Service is running under a Windows NT account and therefore doesn't have access to the backup location.

My understanding is that backup jobs run under the SQLAgentService login though and not the SQLService login so as long as the SQLAgent account is a domain account and has access to the backup folder it should be working.

Is this correct? Or do backups in fact run under the SQLService login and that login will need permissions to the backup folder and not the SQLAgent account?

If so I will need to change the SQLService login to a domain account so that I can provide it access to the backup folder that's on another server which i was hesitant on doing unless required as I'm trying to avoid restarting the server.
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40565 Visits: 32666
Nope, the Agent doesn't do the backups, the SQL Server executable and service does. That needs the permissions.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search