Using database and log restore
The restore feature in SQL Server is used for data recovery in case of corruption and heavily relies on how data is backed up. In this section, we will cover the following topics:
- Preparation steps before the restore process starts
- Restore scenarios, depending on backup strategies
We'll start with the preparation steps first.
Preparing for restore
Before a database is restored, we must decide on the type of corruption and which backup sets are already available for restore. If we have more backups to be restored (a 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) for very detailed transaction actions. These transaction log records are written before the action is...
