How to encrypt SQL server backups
Make sure to encrypt SQL Server backups in order to add another level of security to your data. Adding this option […]
How to get SQL Server backup email notification
Ever needed to know if your backup job has finished successfully or has encountered any issues? Would you like to get from SQL […]
How to remove old SQL Server backups
How to remove old SQL Server backups – quick tutorial: Managing storage space occupied by your backups is a task that should not […]
SQLBackupAndFTP: the SQL Backup master
Everyone knows that the most important task that any DBA has to be able to do is to take safe and reliable […]
How to specify backup’s lifetime
When you are going to save backups on any storage destination (on local storage or on a cloud service), the first questions […]
Set 7zip CPU priority to LOW
As you might know already if you’re creating backups and also monitoring your server’s resources you have seen that the CPU is […]
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 […]
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 […]
[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 […]
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 […]