The database has disappeared on MS SQL Server. How to find and restore?

Question

Data recovery

There was a database, then the server license expired or an error occurred, after which the DB_Name.mdf database simply disappeared. There are tempdb.mdf files in the same folder. I created another server and decided to include this file. It has a table dbo.#DirectoryTree____ and there is a value DB_Name.zip.
The base seems to have sunk into the ground. I already drink valerian. Is there a chance to restore the database? this temp file is the same size as the backups, but the backups I made are very old.

Answer 1

Admins are divided into those who do not yet make backups, and those who already do.

Answer 2

TempDB is a temporary database that is recreated when SQL Server starts.
Are you sure that your database was in the same place as the rest of the databases? Check the LOBs on the server, maybe it's stored elsewhere and unmounted.
Also, if the server is virtual, there is a possibility that you started from another snapshot due to some errors, I had such an example from life. Then, Sergei Gornostaev very accurately outlined the situation , amen .