Continuing from my earlier post about backup strategy I will explain on how to restore database from full, differential and log backups.
Assuming we have four backup files on disk which are testdb_full.bak, testdb_differential.bak, testdb_log_1.bak, testdb_log_2.bak. These files were created during backup processes with its sequence are full, differential, first log and second log.
We name the database with ‘TestDB’.
First of all open SQL Server Management Studio and restore the full backup with norecovery option with below syntax: