SQLBackupAndFTP's blog
Effortless SQL Server backups
  • Our Product
  • Features & Prices
  • Download
  • Purchase
  • Forum
  • Support
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

  • 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

Backup Storages

  • How to Backup SQL Server to FTP Server watch on youtube
  • 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 watch on youtube
  • How to Backup SQL Server to Azure Storage watch on youtube
  • How to Backup SQL Server to Amazon S3 watch on youtube
  • How to Backup SQL Server to OneDrive watch on youtube
  • How to Backup SQL Server to Dropbox watch on youtube
  • How to Backup SQL Server to Google Drive watch on youtube
  • How to save SQL Server backups to Azure watch on youtube

Database-related settings

  • How to skip databases in Offline state in SQLBackupAndFTP
  • How to connect to MS SQL LocalDb?

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

Errors

  • Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile
  • The server principal “NT AUTHORITY\SYSTEM” is not able to access the database “database-name” under the current security context
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 the 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 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 the “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…

October 11, 2016

How to Restore SQL Server Database from backup

This article shows several ways of how you can restore a SQL Server database backup. In particular, we will consider how to restore a database

  1. using T-SQL commands
  2. using SQL Server Management Studio
  3. using SQLBackupAndFTP application

More…

September 30, 2016

BACKUP LOG cannot be performed because there is no current database backup

Working with SQL Server you face a  lot of different error messages. Some of them can be solved in a minute, others required more time. In this blog post, we are going to talk about error messages like “BACKUP LOG cannot be performed because there is no current database backup.” Here is a full error message:

Msg 4214, Level 16, State 1, Line 1
BACKUP LOG cannot be performed because there is no current database backup.
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.

More…

«< 6 7 8 9 10 >»

↑

© SQLBackupAndFTP's blog 2022
Powered by WordPress • Themify WordPress Themes