All posts by Alex

How to migrate to SqlBackupAndFtp 11 from the previous versions

SBF v11 is in Beta as of now. This article is for future reference only. There is no way to upgrade to v11 while it is in Beta, no license keys are given. While in Beta, v11 is fully functional and is equivalent to the Professional version.

If you want to migrate to SqlBackupAndFtp 11 you can simply install the new version over the previous one. You do not need to uninstall  the old version.  All scheduled backups will be automatically imported and you should not do anything else. Continue reading How to migrate to SqlBackupAndFtp 11 from the previous versions

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.

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. Continue reading SqlBackupAndFtp v11 – What’s New?

How Tos – SqlBackupAndFtp

Licensing

Database Backups

Backup Storages

Database-related settings

Security & Reliability

Errors

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. Continue reading What are the most common backup strategies?

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. 

Continue reading A nonrecoverable I/O error occurred on file