When executing the backup of my version 12.6.14 SQLBackupAndFTP the system throws the following error:
09/05/2022 15:09:58 [Error] Failed to back up database “Security” with backup type “Full”: Backup media not found: “C :\Program Files\Microsoft SQL Server\MSSQL10_50.TL\MSSQL\Backup\Security202205091509.bak”.
Regarding your question about performing remote backups as if they were local using the MSSQL Server(Local) connection, I’d like to clarify that this functionality is not feasible.
However, you have two options to achieve backups:
Install SQLBackupAndFTP directly on the server where SQL Server is hosted. This allows you to perform backups locally without needing to establish a remote connection.
Perform remote backups using MSSQL Server(Remote) connection.
If you have any further questions, please feel free to reach out.