Please see the more recent and detailed article:
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
If you run a backup job manually, it successfully works, however, when it runs as a scheduled job it fails with the error message: “Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile”, you can around this issue with one of the below solutions. Continue reading Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile
If you encounter the error message:
[DBMS-MSSQL:11006#916] The server principal "NT AUTHORITY\SYSTEM" is not able to access the database <database-name> under the current security context
you will find the solution below:
Go to the “SQL Server” sections and click on the gear button. At the opened “Connect to Server” window you need to select “Microsoft SQ: Server (local) as your Server type, choose “Windows Authentication” and enter User Name and Password. Press “Test Connection” to make sure that you have specified the correct data and then click on “Save & Close” to save and apply new settings. Continue reading [DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database
If you encounter a situation in which you run a job to backup your database to Dropbox for example or to another storage service you get an error saying: “SBFDS5006″: Dropbox exception > Failed to upload file”; “Status: 0. Description: The operation was cancelled“
Although the application might try multiple times to run this job, but without success.
Most admins will prefer to create, due to security reasons, accounts for any system with minimum privilieges.
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
Let’s assume you have a large database and SQLBackupAndFTP is using 7-zip to compress your database’s backups. You might notice that during the compression phase of the backup operation the CPU utilization of your server is about 100% and in order to reduce this, you will just have to …
Continue reading How to lower the priority of 7-zip process
What is WARNING: Database <db-name> is SUSPECT? You have probably seen databases marked as SUSPECT in SSMS and you don’t know what it represents. Read the below article to find out more details about this!
Continue reading What is WARNING: Database db-name is SUSPECT?
When 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
Does uploading your backup to Amazon S3 with SQLBackupAndFTP take a long time?
This article will show you what to do to drastically reduce the time it takes.
Continue reading Amazon S3 destination chunk size configuration
Are you interested in learning how to migrate your database from MS SQL 2008 to 2012? If your current Cloud site is running the older version of MS SQL and you would like to update it to the newest 2012 feature-rich version, you have come to the right place. Here is a step-by-step process detailing how you can migrate your database from MS SQL 2008 to 2012: