How 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
Everyone 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
As you might know already if you’re creating backups and also monitoring your server’s resources you have seen that the CPU is used intensively during the compression phase of the backup operation.
Find out in this article how to set 7zip CPU priority to LOW.
Continue reading Set 7zip CPU priority to LOW
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
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: 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
Due to security reasons, most admins will prefer to create accounts for any system with minimum privileges.
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