sqlserver-backup
Installation
SKILL.md
SQL Server Backup & Restore
Use this skill for database backup strategies, restore procedures, and verifying backup integrity.
Recovery Models
Choose the right recovery model before designing your backup strategy.
| Model | Log Truncation | Point-in-Time Recovery | Log Growth Risk | Use When |
|---|---|---|---|---|
| SIMPLE | Auto at checkpoint | ❌ No | Low | Dev, test, non-critical data |
| FULL | On log backup | ✅ Yes | High (must take log backups) | Production — minimizes data loss |
| BULK_LOGGED | On log backup | Partial | Medium | Bulk load periods (then switch back to FULL) |