Manually you may try repairing SQL database by Using DBCC CHECKDB or by rebuilding the database, but such methods are proven to work only certain times and in the end professional recovery solutions are employed.
In case manual methods fail, you may also try using a tool called SQL Database Recovery and using this tool, you can easily repair or recover data from SQL servers and this tool also lets you preview the recovered data before saving.and the tool is compatible with all Windows OS up till the latest Windows 10.
To learn more about this tool, visit: https://www.sysinfotools.com/recover...e-recovery.php

SQL Database Recovery tool fixes all corruption issues of SQL Server database and recovers inaccessible objects from MDF and NDF database files. The software carries out the highest level of non-destructive repair algorithm to preserve database integrity. It has the ability to reconnect MS SQL server automatically, when there is a disruption during the repair process. Try free demo version of Stellar, Kernel, Aryson & SysInfoTools SQL Database Recovery software and know the features & functionalities of this software.

The kernel for SQL server allows for ultimate SQL database recovery from MDF or NDF coruppted files. This can repair your lost database objects to running SQL server..!!

New Way To Do SQL Recovery
 

Use SQL Database Recovery Tool which is designed to resolve all sort of issues present in SQL Database.

Buy only after trying demo version.

Demo Version: http://www.databasefilerecovery.com/...e-recovery.exe

If you are seeking a simple and fast solution to recover damaged or corrupt SQL database then try this advanced SQL Database Recovery software which is capable to repair both primary and secondary database files (.mdf/.ndf) with easy steps. This software support to repair database files of SQL Server 2019, 2017, 2016, 2014, 2012, and all its below versions. Also, it allow users to export the recovered data directly to the live SQL database or as SQL script. In addition to this, the software is capable to fix all the SQL Server errors without any data loss issue. Download the free trial edition and check the working of the tool before purchasing its licensed version.