Backup i Restore¶
Automatyczne backupy¶
Azure SQL Database¶
Automatyczne backupy: - Point-in-Time Restore: 7-35 dni - Long-term retention: do 10 lat
Azure Portal → SQL Database → Backups
Restore z Point-in-Time¶
az sql db restore \
--resource-group masaku-prod \
--server masaku-sql-prod \
--name Masaku \
--dest-name Masaku-restored \
--time "2025-01-24T10:00:00Z"
Manual backup¶
Database¶
# Export
az sql db export \
--resource-group masaku-prod \
--server masaku-sql-prod \
--name Masaku \
--admin-user sqladmin \
--admin-password xxx \
--storage-key xxx \
--storage-key-type StorageAccessKey \
--storage-uri https://masakubackup.blob.core.windows.net/backups/Masaku.bacpac
Files (Azure Storage)¶
Backupy automatyczne - GRS (Geo-Redundant Storage)
Disaster Recovery¶
Plan DR: 1. Backup codziennie (automated) 2. Testing restore co miesiąc 3. Dokumentacja procedur 4. RTO: 4h, RPO: 1h