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) for very detailed transaction actions. These transaction log records are written before the action is actually done against data pages in the buffer cache (transaction log records are buffered for a short time and written in batch actually, but for a conceptual view, it does not...