All posts by Alexander Omelchenko

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

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: Continue reading This BACKUP or RESTORE command is not supported on a database mirror or secondary replica

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 time comes to make a backup according to the schedule you receive the following error message:   Continue reading Access denied for user “Server\User”

Restore Database from Backup

In that article let’s explore one of the several major elements in the daily life of every DBA. This is SQL Server restore database from backup process. If you are looking for the best and the easiest way to restore database from backup is to apply the simple software – One-Click Restore. You can install this simple tool on your machine or desktop computer and restore your database automatically quickly. However beneath let’s explore the other techniques of database restoration. Continue reading Restore Database from Backup

Backup and Restore Utility SQLBackupAndFTP & One-Click Restore

In that blog post let’s talk about one of the crucial questions in the life of every DBA it is SQL Server database backup and restores process, which you can cover using backup and restore utility SQLBackupAndFTP & One-Click Restore. You can install these tools on your machine or personal computer and they will do all work for you. So here is a short tutorial how you can protect your SQL Server database using backup and restore utility. Continue reading Backup and Restore Utility SQLBackupAndFTP & One-Click Restore

Restore SQL Database From Backup

In this blog post let’s discuss one of the main parts in the life of every DBA this is how to restore SQL database from backup. The easiest way to restore your SQL Server database from the full backup is to use the simple tool – One-Click Restore. You can install this tool on your server or computer and restore your database automatically promptly. But below let’s discuss the other ways of database restoration. Continue reading Restore SQL Database From Backup

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, another required more time. In this blog post, we are going to talk about error message 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.

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