One of the most important operations and tasks that need to be performed on a database is the backup process.
In this sense, you can prompt to backup a SQL Server database from the command line using SQLBackupAndFTP version 10 or earlier with some additional parameters, which are also passed in the command terminal.
Continue reading Backup SQL Server Database from command line with SQLBackupAndFTP version 10 or earlier
Backing up your database is one of the most important tasks a DBA should have set. There are multiple options in terms of backing up a database, for instance, you could backup a SQL Server database to NAS drives.
If you prefer this option or if your organization requires you that you backup your databases on your local network then you can count on SQLBackupAndFTP to assist you with this and make the job much easier!
Continue reading How to backup a SQL Server database to NAS drive
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
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
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
If you have been using SQLBackupAndFTP with the advanced options to schedule the automatic creation of your backups, there is a possibility that during the backup operation, someone manually stops the process.
In the event that such a thing happens, there is a chance that trying to re-run the operation through a schedule you are going to encounter a problem with the schedule not being initiated.