Backup and Restore Strategies

Intermediate Updated March 20, 2025

💾 Backup and Restore Strategies

SQL Server supports several backup options:

| Backup Type  | Use Case                                         |
|--------------|--------------------------------------------------|
| Full         | Complete DB backup                               |
| Differential | Changes since last full backup                   |
| Transaction Log | Point-in-time recovery                        |

-- Full backup
BACKUP DATABASE LibraryDB TO DISK = 'D:\Backups\LibraryDB.bak';

-- Restore backup
RESTORE DATABASE LibraryDB FROM DISK = 'D:\Backups\LibraryDB.bak';