Tag Archives: backup

SQL Server Remote Backup

Please see the more recent and detailed articles:

Remote SQL Server backups explained or

How to backup remote SQL Server database using SQLBackupAndFTP

Original article:

In this article, we will talk about the remote backups option which is provided as a Beta feature in SQLBackupAndFTP. Continue reading this article to find out more details. Continue reading SQL Server Remote Backup

Set Amazon S3 access policy to minimum permission

Amazon S3 access policy to minimum permission
Due to security reasons, most admins will prefer to create accounts for any system with minimum privileges.
So now you might wonder how to create a user for Amazon S3 service that has minimum permissions in order to backup databases with SQLBackupAndFTP in a certain bucket and folder? It’s quite easy…

Continue reading Set Amazon S3 access policy to minimum permission

Set TraceLog attribute of Google Drive destination to TRUE value

Set TraceLog attribute of Google Drive destination to TRUE valueWhen using SQLBackupAndFTP with Google Drive as your cloud storage for your backup files, you might encounter an error that reports “Invalid credentials”.
Read the below article in order to find out what to do in order to quickly solve this. Continue reading Set TraceLog attribute of Google Drive destination to TRUE value

Advanced SBF Service log configuration

If you have been using SQLBackupAndFTP with the advanced options to schedule the automatic creation of your backups, there is a possibility that during the backup operation, someone manually stops the process.

In the event that such a thing happens, there is a chance that trying to re-run the operation through a schedule you are going to encounter a problem with the schedule not being initiated.

Continue reading Advanced SBF Service log configuration