The easiest way to backup SQL databases automatically on schedule is to use SQLBackupAndFTP. Just follow these simple steps: Continue reading How to Backup SQL Database automatically using SQLBackupAndFTP
Cannot Open Backup Device Operating System Error 5(Access is Denied)
Sometimes when you backup your SQL Server using SQLBackupAndFTP, SSMS or T-SQL Commands you can face the following issue Cannot Open Backup Device Operating System Error 5(Access is Denied). This has to be the most famous issue in taking SQL Server database backups. There are several reasons for this error and there are various ways to solve it. Some time ago we met this issue and for a time we were creating a backup and discovered a very helpful resolution to the issue. The issue was as described beneath:
Msg 3201, Level 16, State 1, Line 4 Cannot open backup device 'D:\Adventureworks.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 4 BACKUP DATABASE is terminating abnormally.
Continue reading Cannot Open Backup Device Operating System Error 5(Access is Denied)
How to Backup SQL Server 2016
Nowadays, there are several ways of how to backup the SQL Server 2016 database. In this article, we are going to take a look at how to backup SQL Server 2016 and what features have been added. Continue reading How to Backup SQL Server 2016
How to Backup SQL Server to FTP Server
The most common way to perform SQL Server database backup it to use SSMS or T-SQL Commands. But is it convenient to make backups using T-SQL Commands or SSMS and send them to FTP Server on a regular basis? With the help of SQLBackupAndFTP, you can do this job just in a few minutes. Continue reading How to Backup SQL Server to FTP Server
How to Backup SQL Server to Local or Network Folder
How much time do you usually spend to make your SQL Server database backup? Is your method convenient and reliable? Assume that your need to perform full backups every 24 hours, differential backups every 6 hours, and transaction log backups every 30 minutes. How much time would you spend if you prefer to make SQL Server database backups with the help of T-SQL Commands or SSMS? You can simply use SQLBackupAndFTP to create a backup job that will make all backups according to your schedule in less than 2 minutes. Continue reading How to Backup SQL Server to Local or Network Folder
How to Backup SQL Server to Azure Storage
You can perform SQL Server database backups in many ways, for example, you can make backups with the help of T-SQL Commands or SSMS. Also, you can choose a destination where your SQL Server backups will be stored, let’s say, Azure Storage. But how much time does it take to create SQL Server backup and then sent it to Azure Storage? With the help of SQLBackupAndFTP, you can perform a backup and then send it for storing to Azure Storage in a few minutes. Continue reading How to Backup SQL Server to Azure Storage
How to Backup SQL Server to Amazon S3
One of the most popular places for storing SQL Server database backups – is Amazon S3. But nowadays there are a lot of ways how to make SQL Server backup and many methods on how to send them to Amazon S3. But how much time do you usually spend doing it? With the help of SQLBackupAndFTP, you can backup SQL Server to Amazon S3 in a few minutes. Continue reading How to Backup SQL Server to Amazon S3
How to Backup SQL Server to Box
Nowadays it is really convenient to make SQL Server backups and send them to store somewhere in the cloud, for example to Box. How much time does it usually take you to make a backup with the help of T-SQL Command or SSMS and then send backups to Box? But what if you need to make a full backup every 24 hours, differential backups every four hours, and transaction log backups every 30 minutes, how much time will you spend in this case? Luckily you can do backup SQL Server to Box in 3 minutes with the help of SQLBackupAndFTP. Continue reading How to Backup SQL Server to Box
How to Backup SQL Server to OneDrive
If you are looking for the easiest way how to backup SQL Server to OneDrive, use SQLBackupAndFTP utility. With the help of SQLBackupAndFTP, you can set up scheduled SQL Server backup to OneDrive in just 3 minutes. Here you go: Continue reading How to Backup SQL Server to OneDrive
How to Backup SQL Server to Dropbox
Where do you store your backups? Do you store them in the local folder or somewhere in the cloud? How long does it take to make SQL Server database backup and then to move it to, for example, Dropbox? Why not just simply use SQLBackupAndFTP for automatically making scheduled SQL Server backups to Dropbox? It makes your life much easier. Continue reading How to Backup SQL Server to Dropbox