SQL Azure Backup and Restore
Importing a Database from
on-premises SQL Server to Azure SQL database is done by wrapping up everything
in a BACPAC file.
You need to create a Microsoft Azure
storage account which is required to access your data in the cloud through
BACPAC files.
Create a .bacpac file containing all
your data from your on-premises SQL server and upload it to the blob container
in the Azure storage account. Then you can import the uploaded .bacpac file
into SQL database.
Self-Service Restore
Azure SQL database backs up your databases
automatically in three types such as:
1.
Full Backup: SQL server technology backs up the
whole database including your transaction logs and the whole data can be
recovered after the full backup restore.
2.
Differential Backup: A differential backup backs up the
most recent data which is remained after the full backup. It offers to take
regular data backups, which eliminates the risk of data loss.
3.
Transaction Log Backup: It helps to back up the logs at
frequent intervals which reduces the work loss exposure and to truncate the
transaction log.
Backup Properties
Backup Storage: SQL database offers up to 200% of
your provisioned database size as your backup storage with zero additional
cost.
Backup Schedule: After the creation of the database
the first full backup will be initiated immediately. After that, all further
backups are invoked automatically and managed in the background.
Backup Retention: The retention period for SQL
database backup is based on the database service-tier. For Basic service tier,
the daily restore point is retained for 7 days, if it is the Standard / premium
service tier you can restore to a specific point in time within 35 days.
Comments
Post a Comment