Reference
Required Permissions
| Operation | Required Role |
|---|---|
| Backup | db_backupoperator database role, or sysadmin |
| Restore | sysadmin or dbcreator server role |
Quick Reference
| Task | SSMS Path |
|---|---|
| Full backup | Right-click DB → Tasks → Back Up → Type: Full |
| Differential backup | Right-click DB → Tasks → Back Up → Type: Differential |
| Transaction log backup | Right-click DB → Tasks → Back Up → Type: Transaction Log |
| Schedule a backup | In the Back Up window → Script → Script Action to Job |
| Restore a database | Right-click Databases → Restore Database |
| Point-in-time restore | Restore Database → General → Timeline… |
| Restore to new name/server | Restore Database → General (rename) + Files (relocate) |