Please enable JavaScript.
Coggle requires JavaScript to display documents.
2.5 backup Azure sql database - Coggle Diagram
2.5 backup Azure sql database
SQL Database automatically creates database backups
RA-GRS
SQL Database service determines the exact timing of all database backups, because it balances the overall system workload
Full backups
:
everything in the database and the transaction logs is backed up. SQL Database makes a full backup once a week.
Differential backups
:
everything that changed since the last full backup is backed up. SQL Database makes a differential backup every 12 hours.
Transactional backups
:
the contents of the transaction logs are backed up. SQL Database makes a transaction log backup every 5 to 10 minutes.
restore
Restore an existing database.
Restore a deleted database up to the time when it was deleted.
Restore the database to an alternative location or region.
Restore a database from a long-term backup by using long-term retention (LTR).
retention
basic
1 week
standard
5 week
premium
5 week
long-term retention
LTR
are kept up to 10 years
copies them to different blobs
long-term retention policy
Recover data
you must create a
new database
You can't restore a database over an existing database
on the same DB server
to a specified point in time within the retention period.
to the deletion time for a deleted database.
on another DB server - same region
to the point of the most recent backups.
on another DB server - oteher region
to the point of the most recent replicated backups.
point-in-time restore
Database replacement
.
make sure you specify the same compute size and service tier as the original.
Then rename the original db and give the restored database the original name by using T-SQL ALTER DATABASE commands.
Data recovery
.
you don't need to rename the original
use T-SQL commands to extract the data. Then insert the data into the original bd.
Restore a deleted database
database server's Overview page. Then, in the Operations area, select Deleted databases