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! More…
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.
Please see the more recent and detailed article:
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: “SBFDS5006″: Dropbox exception > Failed to upload file”; “Status: 0. Description: The operation was cancelled“ Although the application might try multiple times to run this job, but without success.
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 utilisation of your server is about 100% and in order to reduce this you will just have to … More…
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.