BACKUP DATABASE myDB TO DISK = @name WITH FORMAT, MEDIANAME = 'Z_SQLServerBackups', NAME = 'Full Backup of myDB';
We have a new installation of SQL server 2019 on same machine (previously version 2016).
I have tried various suggestions from dba.stackexchange (e.g. this one) or internet:
- multiple user accounts on SQL server agent (all of them have access to any location tried)
- create credentials for the backup job failing on "Cannot open backup device"
I am desperate, any suggestion on how to enable saving a backup to any local disk/network location will be appreciated very much