In the event of a database failure, you have the most flexibility restoring databases using the full recovery model. In addition to preserving data modifications stored in the transaction log, the full recovery model allows you to restore a database to a specific point in time. For example, if an erroneous modification corrupted your data at 2:36AM on Monday, you could use SQL Server’s point-in-time restore to roll your database back to 2:35AM, wiping out the effects of the error.
Read more about SQL Server Recovery Models.
Read more about SQL Server Recovery Models.
Great Tips once my sql database has been corrupted that time i have used SQL Recovery software named as Stellar Phoenix SQL Recovery Software its great software to repair and recover your corrupted sql database.