For any SQL Server DBA who’s been in the field for a long time, you know that the exercise of restoring backups taken in SQL Server 2000 (and even SQL Server 2005 without using the CHECKSUM option) was many times a sweat-filled lottery. You usually gambled and/ or prayed to your respective deity that your backups would actually work. Why? Because you knew that restore failures were all too common. Despite SQL Server’s assurance that all was well because you had already verified your backups with the RESTORE VERIFYONLY option. So why was this the case? Why did restore operations fail so frequently? Let’s delve a bit more into the innards of the RESTORE VERIFYONLY and CHECKSUM options to find out.

Continue reading RESTORE VERIFYONLY and CHECKSUM options

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


Database Backups

Backup Storages

Database-related settings

Security & Reliability


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:

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