Pt. punctul 3: restore cel mai recent diff  WITH NORECOVERY

Pt. punctul 4: restore secvential pentru toate backup-urile de log facute de la ultimul diff incoace WITH NORECOVERY

(daca exista "tail log" se poate restaura si el WITH NORECOVERY) 

5. RESTORE DATABASE [database] WITH RECOVERY

Din BOL:

The basic RESTORE syntax for the restore sequence is:

1. RESTORE DATABASE database FROM full database backup WITH NORECOVERY;
   
2. RESTORE DATABASE database FROM full_differential_backup WITH NORECOVERY;
   
3. RESTORE LOG database FROM log_backup WITH NORECOVERY;
   Repeat this restore-log step for each additional log backup.
   
4. RESTORE DATABASE database WITH RECOVERY;