SQLBackupAndFTP's blog | Page 4 | Effortless SQL Server backups

February 17, 2017

How to backup Azure SQL Database to Local Machine

Being a managed cloud database Azure SQL Database provides built-in functionality for automatic database backups. It allows you to restore your database to any point in the past and those backups are kept in a reliable geo-redundant storage. So why do we need other tools like SqlBackupAndFtp to backup of Azure SQL Database? This can be the case when you need to get a copy of your database locally, outside Azure infrastructure. In this post, you can find a step-by-step guide on how to backup Microsoft Azure SQL Database with the help of SQLBackupAndFTP.

More…

February 16, 2017

How SqlBackupAndFtp 11 differs from the previous versions?

SqlBackupAndFtp 11 is significantly different from the previous versions – see the detailed post on what is new in v11. Here you can get a birds eye view on what is new and what is missing in the new version.
More…

February 1, 2017

SqlBackupAndFtp v11 – What’s New?

Have you seen our brand-new version 11 of SqlBackupAndFtp? If yes, then you have also noticed that its looks and feels very different from its predecessor (compare features in the new & old versions). That’s right – this release is built from scratch based on our eight-year-experience creating SQL Server backup software and close to 1,000,000 installations of the previous versions.

If you have used the old version, this post will help you to quickly grasp the main points that make the new version better. If you are new to SqlBackupAndFtp, you can read this as a quick introduction. More…

January 31, 2017

How Tos – SqlBackupAndFtp

Licensing

How to move SQLBackupAndFTP license to a New Computer / Server

Database Backups

Backup Storages

Database-related settings

Security & Reliability

Errors

November 28, 2016

What are the most common backup strategies?

Choosing a database backup strategy is crucial because it determines how data in your SQL Server database is protected. You can read more about database backup strategies, but here we are going to present you some statistics on how SQLBackupAndFTP users backup their databases. The numbers are based on a sample of about a thousand users. More…

November 24, 2016

Where Do People Prefer Keeping Their SQL Backups?

Have you been asking yourself what kind of storage is the most appropriate for keeping your database backup? While there is no 100% perfect answer, in this blog post we are going to share with you some statistics that may help you in this matter. More…

October 14, 2016

How to Move SQLBackupAndFTP License to a New Computer / Server

Sometimes it is necessary to move SQLBackupAndFTP license to a new computer or server, but how to do it? Here is the short tutorial which will help you to move your SQLBackupAndFTP license to a new computer or server just in a few minutes. More…

October 14, 2016

A nonrecoverable I/O error occurred on file

Making scheduled SQL Server database backups you can receive the following error message:

DETAILED LOG: 
10/10/2016 11:32:40 Creating backup of Adventureworks to C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Backup (full) 
10/10/2016 11:32:40 ERROR: A nonrecoverable I/O error occurred on file "C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Backup\\Adventureworks201610101132.bak:" 112(failed to retrieve text for this error. Reason: 15105). 
BACKUP DATABASE is terminating abnormally.

More…

October 13, 2016

This BACKUP or RESTORE command is not supported on a database mirror or secondary replica

During the backup process, you can get different error messages, it doesn’t matter how you make SQL Server database backups. You can backup your database using T-SQL Commands, SSMS or SQLBackupAndFTP. Assume during the backup process, you receive the following error message: More…

October 13, 2016

Access denied for user “Server\User”

Making scheduled SQL Server database backups with the help of SQLBackupAndFTP you can face with some issues. Here we are going to discuss one of them. Let’s assume you created a scheduled database backup job and made all necessary settings, even clicked “Run Now” button to check the backup job and everything works perfectly. But when a time comes to make a backup according to the schedule you receive the following error message: More…