May 26, 2009 at 12:34 am
Dear Sir,
I am facing a lot of problem while taking backup from my sql server DB.
I am getting the below Error.
'\\servername\dbbackup\test.bak'. Operating system error 5(Access is denied.).
Can you please suggest me some good solution for this problem.
Regards,
Mohammad Zubair Pasha.
May 26, 2009 at 1:17 am
Sounds like the account under which you execute the backup, doesn't have enough permissions on the network share.
If you run the job under a local account, you have to give it at least change permission on the share.
[font="Verdana"]Markus Bohse[/font]
May 26, 2009 at 1:42 am
Dear Sir,
The problem solved by giving Administrator in sql server configuration manager right click sql server(MSSqlserver) properties logon as Administrator Account.
It Solved....Thanks God.
Regards,
Mohammad Zubair Pasha.
June 24, 2010 at 1:32 am
Hi Sir,
what if the job will be run on the local server. But the path for the backup plan is directed to other server? It does not accept the path im giving, it says that the backup directory is invalid.. but if I tried to access the path in run command i can access it..the shared folder has the sa adn Administrator's permission 'full Control'.
Please advise.
Thank you.
-ynel-
June 24, 2010 at 7:19 pm
You should create a dump device that points to the remote server, then backup to the dump device.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply