Repair Corrupt Database?
Answer Chosen by the Author
-Click “NewQuery” in the Management Studio’s main toolbar. This opens a large text area onthe right side of the screen.
-Click in thetext area and type a Create Database statement using the following Transact-SQLcode as a guide:
CREATE DATABASEMyDatabase ON (FILENAME = 'c:\data files\my_data.mdf'), (FILENAME = ' c:\datafiles\my_data.ldf') FOR ATTACH;
-Click the“Execute” button in the Transact-SQL toolbar, located just under the ManagementStudio’s main toolbar. The Execute button symbol is a right-pointing triangle.SQL Server Management Studio restores the database.
Helpfulresources to explain another methods of restoration and gave more variants ofsql data recovery...
https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox