During a penetration test I found multiple .bak-files for an MSSQL database. I want to restore them all. In a Windows VM I installed SQL Server 2017. For restoring the master database, I put the server in single-user mode and tried restoring the database as follows (also tried the same via SSMS):
RESTORE DATABASE master FROM DISK = 'C:\Foo\<path>\master.bak' WITH MOVE 'master' TO 'C:\Foo\master.mdf', MOVE 'master_log' TO 'C:\Foo\master_log.ldf', REPLACE GO
This gave me an error like:
.. can't be restored because it was created by a different version of the server (13.00.4435) than this server (14...).
I then downloaded MSSQL 2016 with service pack 1 by subscribing to "Visual Studio Dev Essentials" on my.visualstudio.com. Now I got the error:
.. can't be restored because it was created by a different version of the server (13.00.4435) than this server (13.00.4001).
So now I needed to update. I downloaded MSSQL 2016 service pack 2, which gave me the error:
.. can't be restored because it was created by a different version of the server (13.00.4435) than this server (13.00.5026).
So I really seem to require the exact patch. However, I can't find a list of patches with corresponding server versions. Does anyone have an idea on how to find the right patch?
If I could just extract the .bak file to its .mdf- and .ldf files that would be enough. I found a bunch of tools for restoring MSSQL .bak files, but want they all want to connect to a database (to do a simple restore). I'd be very happy if I could either get the right SQL Server version or extract the .bak file.