How to migrate MSSQL database after OS reinstall?

Question

SQL Server

On the server there is Windows in a half-dead state, it is necessary to unload a completely single database in order to then restore it on a server with a reinstalled OS. How to do it right?

Answer 1

How to do it right?

Guide .
And most importantly, MS SQL does not have backward compatibility: files from a new one cannot be connected to an older server.

Answer 2

correct - backup, and in a new place - restore
less correct (emergency) - various options for transferring mdf / lfd storages with subsequent connection