question

MicheleGuion-2665 avatar image
0 Votes"
MicheleGuion-2665 asked MicheleGuion-2665 commented

Database backup and storage location

Hello, I have some questions about data persistency in case of issues in a datacenter.

We use a MSSQL database on Azure.
We keep the first backup of every month.
I can't find where backup are stored.
What happens if the datacenter hosting the database has some kind of problems?
Our backups are safe? Or are they stored in the same datacenter, so they could get corrupted?
And what about point-in-restore (guaranteed for the last 35 days for Premium subscriptions)? Is this guaranteed also in case of issues or the data could be lost?

We use storage, too, to store some kind of files.
Are they safe in case of issues or should we configure a storage replica in another geographic location?

Thanks everybody for your support.

azure-sql-databaseazure-storage-accountsazure-backup
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

How you configured that monthly backup? Are you using Azure Backup or you are exporting (as a bacpac) the database to a storage account?

0 Votes 0 ·

I use Azure Backup.
Should I create a bacpac and put in in a storage account (replicated elsewhere)?

0 Votes 0 ·

1 Answer

deherman-MSFT avatar image
0 Votes"
deherman-MSFT answered MicheleGuion-2665 commented

@MicheleGuion-2665
Apologies for the delayed response. Please find the answers to your questions inline below:

What happens if the datacenter hosting the database has some kind of problems?
What happens will depend on the nature of the failure. If the datacenter is unreachable then your database will be offline. For these scenarios we recommend having a Disaster Recovery Plan in place to restore or failover your database.

Our backups are safe? Or are they stored in the same datacenter, so they could get corrupted?
By default, SQL Database and SQL Managed Instance store data in geo-redundant storage blobs that are replicated to a paired region. This helps to protect against outages impacting backup storage in the primary region and allow you to restore your server to a different region in the event of a disaster. More information on backups can be found here.

And what about point-in-restore (guaranteed for the last 35 days for Premium subscriptions)? Is this guaranteed also in case of issues or the data could be lost?
Same as above, by default backups are geo-redundant.

Are they safe in case of issues or should we configure a storage replica in another geographic location?
Locally redundant storage (LRS) replicates your data three times within a single data center in the primary region. LRS provides at least 99.999999999% (11 nines) durability of objects over a given year. When this durability is not enough you can consider implementing geo-redundancy. More information can be found here.

Hope this answers your questions. Let us know if you need further assistance.



Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you @deherman-MSFT.

So, if I understand correctly about database backups, there is geo-redundancy on a paired region.
Data cannot be lost (unless an atomic war begins, but in this case we will have other problems...), it's only a matter of availability?
You say "by default": how can I check my actual configuration?

When you answer about storage, you talk about 3 replicas in the same datacenter. In this case, if the datacenter has some sort of big issues, data can be lost. Am I right?
Should I opt for GRS/GZRS?

0 Votes 0 ·