SQLBackupAndFTP: the SQL Backup master

SQLBackupAndFTPEveryone knows that the most important task that any DBA has to be able to do is to take safe and reliable database backups.
 Large organizations or companies usually have a team of Database Administrators (DBAs) which execute these tasks and keep their data safe and easily accessible.

Continue reading SQLBackupAndFTP: the SQL Backup master

Sql Server Remote Backup

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

Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile

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

[DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context

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 under the current security context

Configure SQLBackupAndFTP NLog

Configure SQLBackupAndFTP NLog
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.

Continue reading Configure SQLBackupAndFTP NLog

Set Amazon S3 access policy to minimum permission

Amazon S3 access policy to minimum permission
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