When SQL Server is running, it will store all the temporary data, including all temporary tables and store procedures, into a temporary database called tempdb.mdf. When data disaster occurs, if you cannot recover wanted data from the existing mdf and associated ndf files, you may still be able to recover your data from tempdb.mdf, by using DataNumen SQL Recovery, as follows:
- Stop SQL Server Data Engine service.
- Using the Windows search function to search for tempdb.mdf file on the computer where the SQL Server instance is installed.
- After you find the tempdb.mdf, you can select it as the source file to be repaired, and use DataNumen SQL Recovery to repair it.