[SQL Server] SQL database recovery

We describe two ways to restore your database. The first uses only a backup FULL, and the second uses the transaction log backups to do a PITR (Point-In-Time Recovery).

> Restore from a backup FULL

> Restore from a backup FULL and transaction log backups

At the stage of restoring log, you can add as many transaction log backup files as you need to restore.

All files must be restored with the NORECOVERY option, except for the last one, which should be restored with the RECOVERY option to allow access to the database.

If you only want to perform a page recovery rather than a full database recovery, see our blog : [SQL Server] Perform page recovery