I am running the command:
BACKUP DATABASE [TRACKER] TO DISK = '\\POSRANC011\G$\TRACKER_Backup_Feb25.bak'
The server where TRACKER database is POSRANB021. We want to backup the database to a network drive that belongs to POSRANC011 server. The service account of POSRANB021 is a local admin on POSRANC011.
But when the backup command is run we get
Msg 3201, Level 16, State 1, Line 2
Cannot open backup device '\\POSRANC011\G$\TRACKER_Backup_Feb25.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Beyond the service account being a local Admin, what else do we need to make this work?