Restore

The restore feature in SQL Server is used for data recovery in the case of its corruption and heavily relies on how data is backed up. In this section, we will cover the following topics:

• Preparation steps before restore starts
• Restore scenarios depending on backup strategies

Preparing for restore

Before a database is being restored, we have to decide the type of corruption and backup sets already available for restore. If we have more backups to be restored (full backup combined with other backup types), we need to handle the recovery process as well.

The recovery process was described in the Transaction log section, but let's recall the recovery process one more time. SQL Server uses write-ahead-logging (WAL...