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

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

The log in this backup set begins at LSN, which is too recent to apply to the database

All users who’re working with SQL Server sooner or later face with the following error message:

Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 42000000037600001, which is too recent to apply to the database. An earlier log backup that includes LSN 42000000034400001 can be restored.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

Continue reading The log in this backup set begins at LSN, which is too recent to apply to the database

The database was backed up on a server running version

The best way to protect your database is to make schedule backups. You can do it with the help of SQLBackupAndFTP, SSMS or T-SQL Commands. But when you try to restore your database you can receive some errors. In this article, we will show how to solve the next error: “The database was backed up on a server running version”. You can get this error message  during the restoration process. Here is the text of the error message 3169:

Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 13.00.0801. That version is incompatible with this server, which is running version 12.00.4213. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Continue reading The database was backed up on a server running version

Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

The best way to backup your SQL Server databases is to use SQLBackupAndFTP. But if you still backup your SQL Server database with the help of SQL Server Management Studio you can face with the following issue. Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512. Before to solve this case let’s recreate the same error message. Continue reading Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512