How to encrypt SQL server backups

security, SQL Server, sqlbackupandftp, , , ,
database encryption SQLBackupAndFTP
 
Make sure to encrypt SQL Server backups in order to add another level of security to your data. 
Adding this option to your backups is extremely easy with the help of the Encryption option in SQLBackupAndFTP.
 Read the short tutorial in this article below to encrypt your backups. 
Continue reading How to encrypt SQL server backups →

How to get SQL Server backup email notification

database, SQL Server, sqlbackupandftp, , , ,

SQL Server backup email notificationEver needed to know if your backup job has finished successfully or has encountered any issues?

Would you like to get from SQL Server backup email notification to let you know if your task has successfully finished or not?

Read this article to find out how to do this, really easy with the help of SQLBackupAndFTP
Continue reading How to get SQL Server backup email notification →

How to remove old SQL Server backups

cleaning, SQL Server, sqlbackupandftp, , ,

remove old sql server backupHow to remove old SQL Server backups – quick tutorial:

Managing storage space occupied by your backups is a task that should not require a DBA’s time. With SQLBackupAndFTP you can easily remove old SQL Server backups, periodically.

In this article, we will show you how to do this, step by step, so you will never have to worry about old backup files filling up your storage space.
Continue reading How to remove old SQL Server backups →

SQLBackupAndFTP: the SQL Backup master

network drive, SQL Server, sqlbackupandftp, , ,

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

remote, SQL Server, sqlbackupandftp, , , , , ,

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 →

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

sqlbackupandftp

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

amazon, security, sqlbackupandftp

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

failed to open, SQL Server, sqlbackupandftp, , , , ,

Configure SQLBackupAndFTP NLogIf 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: Dropbox exception > Failed to upload file; “Status: 0. Description: The operation was canceled” Although the application might try multiple times to run this job, but without success.
Continue reading Configure SQLBackupAndFTP NLog →