Error on remote SQL Server (BAK)

1

Hello,

Latest version installed.

If I run a job for the SQL Server on the same machine it’s ok, but if I add a job for a SQL Server on another server on the same network, the log generates errors. In that server I see that the BAK was created on the default SQL Server backup folder, but it was not send for folder and cloud destination on job.

Error:
27/03/2026 16:36:52 [Error] Falha no backup do banco de dados “PFR” com “Full” tipo de backup: Backup media not found: “C:\SQL\MSSQL11.PRIV10\MSSQL\Backup\PFR202603271636.bak”.

I don’t want a *.SQL file. I need a *.BAK.

Any way to do that?
Thank you

2

Hi,

This behavior is expected.

In SQLBackupAndFTP, .BAK backups can only be created when the application is installed on the same machine as the SQL Server.

When you connect to a remote SQL Server, the backup is performed over the network, and in this case SQL Server cannot write the .bak file directly to the local filesystem of the machine running SQLBackupAndFTP. Because of this, the application uses a logical backup (script-based, .sql) instead.