Backup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Backup

Author

Topic

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-04-17 : 09:25:14

I got the below error during the backup ..

Please help.

Executed as user: NT AUTHORITY\NETWORK SERVICE. Cannot open backup device '\\test1\tEST2\ts\abc\test4\Data_Backups\SCORETEST\test_123.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-17 : 13:31:44

are you able to access the path specified using the login credentials which is executing BACKUP command?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-04-17 : 14:29:50

Thanks Visakh

I was able to access the path when copied the path in run command
\\test1\tEST2\ts\abc\test4\Data_Backups\SCORETEST

THe job was schedule with my userid but the error shows NT AUTHORITY\NETWORK SERVICE..

I am sure how this NT AUTHORITY\NETWORK SERVICE comes in..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-17 : 14:47:49

ok...that does mean the sql job is using default service account. You can add a proxy account in sql server and configure the agent to use it in job properties. Then give access to above path for the proxy account

see

http://www.databasejournal.com/features/mssql/article.php/3789881/Proxy-Accounts-in-SQL-Server.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-04-17 : 15:19:24

IF i create new proxy account does this affect other jobs.
SInce other jobs are running fine..only the backup to network drive is failing.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-17 : 16:16:25

nope...other jobs will still continue to use default service account. You're just adding a new proxy not messing up with existing service account

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources