SQL Backup to network share with different credentials
Posted on 2013-05-29
I am trying to set up my database backups on a network share with different credentials. The credentials needed to connect to the network share are in a different domain. I am able to connect to it by mapping a network drive but I would like to use the UNC path. It is my understanding that the account used to run SQL server needs to have access to this share. This is not the case. Is there anyway for me to do a successful backup in this scenario? What needs to be changed for it to be successful? Please advise.