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 […]
Category: sqlbackupandftp
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 […]
Set 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 lower the priority of 7-zip process
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 […]