I looked here,
I want to backup my log to a different server. When I do this through the SSMS, I get access denied because my SQLServer Service user is not what the other machine expects, and I did not want to run the MSSQLServer service with a special domain account.
I tried a share that has everyone for SMB and NTFS, but it did not help.
How can I run the
BACKUP LOG command to my mapped drive with a specific username and password that does have permissions?
I considered Powershell's SQL Server cmdlet, but I am on SQL Server 2012 and am unsure if the new PS libraries will corrupt anything.
import-module SqlServer on the server, but it is not found.