If you backup large SQL Server databases with the help of SQLBackupAndFTP then we want to give you some useful recommendations that may speed up the backup process. Continue reading Recommendation on how to Backup Large Databases with SQLBackupAndFTP
SqlBackupAndFTP v11 is a culmination of years of work and our SQL backup experience with close to 1 million installation of the earlier versions. It is significantly better than the previous version in every respect (or anything else on the market). Read SqlBackupAndFtp v11 – What’s New? or How SqlBackupAndFtp 11 differs from the previous versions?
If you have used the previous versions of SqlBackupAndFTP we strongly suggest migrating to v 11. Continue reading How to migrate to SQLBackupAndFTP 11 from the previous versions
Microsoft Azure SQL Database is a managed cloud database designed by Microsoft which are widely used by app developers. It works as a service and runs on a cloud computing platform. Here is a step-by-step guide on how to backup Microsoft Azure SQL Database with the help of SQLBackupAndFTP. Continue reading How to backup and restore Microsoft Azure Cloud SQL Database
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. Continue reading SqlBackupAndFtp v11 – What’s New?
- How to Backup SQL Database Automatically
- How to Backup SQL Server 2016
- How to backup multiple servers
- How to specify backup’s lifetime
- How to remove old backups
- How to lower the priority of 7-zip process
- How to Backup SQL Server to FTP Server
- How to backup to UNC Path
- How to backup a SQL Server database to NAS drive
- How to Backup SQL Server to Local or Network Folder
- How to Backup SQL Server to Azure Storage
- How to Backup SQL Server to Amazon S3
- How to Backup SQL Server to OneDrive
- How to Backup SQL Server to Dropbox
- How to Backup SQL Server to Google Drive
- How to save SQL Server backups to Azure
Security & Reliability
- How to get SQL Server backup Email Notification
- How to verify backup files after backup
- How to perform SQL Server maintenance
- How to encrypt SQL server backups
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?
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. Continue reading Where Do People Prefer Keeping Their SQL Backups?
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. Continue reading How to Move SQLBackupAndFTP License to a New Computer / Server
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.
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: Continue reading This BACKUP or RESTORE command is not supported on a database mirror or secondary replica