All posts by Alex

The database was backed up on a server running version

database, SQL Server, 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

amazon, because, SQL Server

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 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 solving 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 →

SQL Server Backup System Databases

database, MISC, SQL Server

In this post, we are planning to talk about how to make SQL Server backup system databases. The easiest way is to use the simple tool – SQLBackupAndFTP. Planning the backup process should really be one of the points that are crucial in the life of any DBA.
Such simple procedure will definitely save you tons of time and effort in the future. Continue reading SQL Server Backup System Databases →

Cannot Open Backup Device Operating System Error 5(Access is Denied)

adventureworks, network drive, SQL Server

Sometimes when you backup your SQL Server using SQLBackupAndFTP, SSMS or T-SQL Commands you can face the following issue Cannot Open Backup Device Operating System Error 5(Access is Denied). This has to be the most famous issue in taking SQL Server database backups. There are several reasons for this error and there are various ways to solve it. Some time ago we met this issue and for a time we were creating a backup and discovered a very helpful resolution to the issue. The issue was as described beneath:

Msg 3201, Level 16, State 1, Line 4
Cannot open backup device 'D:\Adventureworks.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 4
BACKUP DATABASE is terminating abnormally.

Continue reading Cannot Open Backup Device Operating System Error 5(Access is Denied) →

Backup And Restore SQL Database

database, MISC, restore

If you are looking for a tool to backup and restore SQL database then use simple tool SQLBackupAndFTP. The most typical jokes you’ll discover when mentioning about one particular important responsibility for a DBA goes like this – a Database Administrator requires one of two things, a great backup or an ideal resume. It’s real. If you’re not performing backups and making sure that you can recover databases from those backups, you’re exposing yourself and your company to information loss. Continue reading Backup And Restore SQL Database →

Backup and Restore in SQL Server

MISC, restore, SQL Server

The best way to backup and restore in SQL Server is use SQLBackupAndFTP. Probably one of the most frequent jokes you will hear while mentioning over probably the essential jobs for a Database Administrator goes like this – a Database Administrator needs one of two things, an ideal backup or a good resume. It’s truthful. If you’re not performing backups and making sure that you can restore databases from those backups, you’re exposing yourself and your company to files loss. Continue reading Backup and Restore in SQL Server →

Backup and Recovery in SQL Server

differential, MISC, SQL Server

A process, which called backup and recovery in SQL Server is crucial for your data. Use SQLBackupAndFTP to make scheduled backups and use One-Click SQL Restore to restore your full backups. Do you really have to make backup and recovery in SQL Server? Certainly. Unless you don’t care about your data or you don’t mind having to fully recreate your database in the event of a disaster, you need a way of restoring the database to a usable point. There are numerous ways how to perform Backup and Recovery in SQL Server, but the simplest is to use SQLBackupAndFTP application. Continue reading Backup and Recovery in SQL Server →