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.
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.
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.
What is LocalDB and how can you connect to it using SQLBackupAndFTP?
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 … Continue reading How to lower the priority of 7-zip process
What is WARNING: Database <db-name> is SUSPECT? You have probably seen a databases marked as SUSPECT in SSMS and you don’t know what it represents. Read below article to find out more details about this!
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.
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.