keep getting random errors everytime i try to restore a database

Alex Negrich 0 Reputation points
2026-08-10T15:54:44.6833333+00:00

Hello, I would love to have some remote assistance with my issue. I'm trying to restore a database from an old computer to a new one, but the old computer is on version 12 and any new computer I try to use wants me to upgrade to version 22, and I keep getting different errors every time. I'm so confused, I've tried multiple computers, different versions of MS SQL Server Management Studio and none of them will let me restore my database. It either says my version is not up to date, wont install correctly, or I don't have permission to make this kind of change. I tried the link below but I had no luck.

TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'fuelmaster' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The database was backed up on a server running version 15.00.2000. That version is incompatible with this server, which is running version 12.00.6179. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.6179.1+((SQL14_SP3_GDR).230727-1936)&LinkId=20476

I would like to sit down with a tech and either call or remote session. Thank you for your time.

SQL Server Database Engine
0 comments No comments

2 answers

Sort by: Oldest
  1. Deepesh Dhake 1,325 Reputation points
    2026-08-10T18:43:31.99+00:00

    Your backup was made on SQL Server 2019 (version 15.00). You're trying to restore it onto SQL Server 2014 (version 12.00). SQL Server can only restore forward to the same or newer version. So the target needs to be 2019 or newer, not older.

    The fix:

    Install SQL Server 2019 or 2022 on the new computer, then restore the fuelmaster backup into that instance. Once the engine is 2019+, the restore will succeed.

    Was this answer helpful?

    0 comments No comments

  2. Duan Steyn 0 Reputation points
    2026-11-22T10:31:26.42+00:00

    The key line is "backed up on a server running version 15.00.2000 … this server, which is running version 12.00.6179". 15.00 is SQL Server 2019 and 12.00 is SQL Server 2014. SQL Server can only restore onto the same version or a newer one, so no SSMS version will make a 2014 instance accept this backup.

    So my suggestion is, on the new machine, install SQL Server 2019 or 2022. Express or Developer edition is fine and free. The "version 22" the tool keep offering is SQL Server 2022.

    Make sure SSMS is connected to the new instance when you restore. If 2014 is still installed, the new one usually has its own name (for example .\SQLEXPRESS01, or the name you chose in setup). Restoring while connected to the old instance gives exactly the same error. SELECT @@VERSION in a query window tells you which one you're on. It should say 15.x or 16.x.

    Restore with the new data paths (the MOVE options in the restore dialog's Files page).

    If you only need the data out of the backup (for example into Excel) and don't need it running on SQL Server, there's another option (shameless plug XD) I built a free browser tool that opens a .bak without SQL Server. It shows the version, the tables and their first rows, and exports a table to CSV or Excel. The file doesn't get uploaded, so it's privacy first: https://fileviewkit.com/sql-server-bak-viewer/

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.