May 28, 2024 at 12:54 pm
Dear Friends,
Would be glad if any of you can help in a backup related issue I am stuck in.
I am trying to take a database backup to two network locations , and mapped drives.
The difference between the two targets is the domain. The source SSMS session from \\a.b.c.d\backup to target \\a.b.c.e\\backup works well and SQL server writes the backup file but the same SSMS session from \\a.b.c.d\backup fails to write to \\a.b.y.z\backup throwing 'Access Denied' error.If we check on OS level by creating a sample file, its able to create on both the locations.Many thanks in advance for any advices for making it work.
Thanks and best regards
Arshad
May 28, 2024 at 12:58 pm
You need to grant the sql server service account auth to get to the new backup file location/share
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 28, 2024 at 1:00 pm
Try this query:
select *
from sys.dm_server_services
You want to make sure the service account associated with the database engine has the permission to write to the backup folder as that is what is running BACKUP/RESTORE.
May 28, 2024 at 1:02 pm
The backup is run by the database engine service account.
Run the below query to find that service_account:
select *
from sys.dm_server_services
May 29, 2024 at 11:25 am
Hi Friends,
Its working fine..it was the privileges issue for that account. The servers were out of the domain, and hence are not connected to the domain then the network backup starts to work.Thank you for your advises.
May 29, 2024 at 11:53 am
Thank you for the feedback 🙂
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply