Backup SQL Server database remotely to a specific user shared restricted folder

Question

I want to back up other computers' databases on my network to a network-shared folder on its C:\ disk remotely, the shared folder is only open to its own user.

It works fine if I give everyone permission to the shared folder, but I need to restrict it and I don't know how to do the code part.

If only one user can access that folder then most certainly the Service Account that SQL Server is running under isn't going to be able to access it; so therefore you need to grant the SQL Server Service Account access to that share/location. Then you'll be able to BACKUP to the (UNC) path. — Thom A
– Thom A ♦, Commented Sep 15, 2022 at 11:30

Vahid Mousaoghli · Accepted Answer · 2022-09-16 18:11:59Z

1

If you want to take a backup copy of the database in a network path, the User that started the SQL Server service must have write access to that shared folder in the network path. Otherwise you will get an access denied error.

answered Sep 16, 2022 at 18:11

Vahid Mousaoghli

564 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Backup SQL Server database remotely to a specific user shared restricted folder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related