full backup fails

Application issues
1

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”.

2

Hi Sistemas,

Could you please make sure you use the correct server type during the connection? Please find more details on how to backup the Remote SQL Server in the following blog post Remote SQL Server backups explained – SQLBackupAndFTP's blog

If you have any other questions, please let us know.

Thank you!

3

Any other ways than SQL Server (Remote)?
Can we do backup SQL Server(Local) instead?

image
image878×581 41.6 KB

I read that SQLBACKUPANDFTP need to access the D\blablabla\backup folder on the DB server. How do I grant SQLBACKUPANDFTP to that DB Server?

4

Hello Faisal_Rifqi,

Thank you for your inquiry.

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:

  1. 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.
  2. Perform remote backups using MSSQL Server(Remote) connection.

If you have any further questions, please feel free to reach out.

Regards,

Oleg