In the case of database corruption, first, you should restore the database from the updated backup. If your backup is not updated then, you need to repair SQL database to get all the data. To repair corrupt SQL database, you need to find the exact reason for the corruption.
If it is clustered index then, you need to repair it. If it is related to non-clustered then, you can rebuild it.
Check this article: https://www.infosecurity-magazine.com/blogs/repairing-sql-database-corruption/
21 People are following this question.