I’d try the procedure described below or third party tool such as

Recovery Toolbox for SQL Server https://repairsql.recoverytoolbox.com/[/url]

If that doesn’t work and database is severely corrupted.

There might be...