This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we need to take to mitigate these potential data losses?
TIA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Chancellor, Joe,
Welcome to Microsoft Q&A forum.
As I understand, you want to know about System Database Backups for Azure SQL Managed Instance.
I am checking internally and will get back to you.
Thanks
Hi Chancellor, Joe,
Wea are yet to receive reply from the internal team.
If the requirement is urgent, I recommend you to raise support case to get insight into it.
Thanks
There isn't a fire, but working on product documentation and couldn't find the answer. I'll report back what they say.
Hi Chancellor, Joe,
We do not support COPY ONLY backup of system databases. That’s by design.
System databases (all but physical master) are being backed up by our automatic backups, so there won’t be any data loss.
Could you please explain more on “if server was lost"?
Thanks
The backup information is stored in the msdb. Login information is stored in the master database. Are we able to restore user databases even though we don't have a backup of master and msdb? The server login information is lost? I haven't been able to find information regarding what it's like for resources that are using LRS and there is a loss of an availability zone.
I do have a meeting in 15 minutes regarding this with support.
I don't see backups of system databases when I query msdb.dbo.backupset in SQLMI.
If the LRS the SQLMI is running on is lost, how can I recover my GRS backed up user databases?
It's a managed service. So if your Managed Instance goes into pieces, it is Microsoft's duty to restore the instance, including system databases.
If I could read that in a document somewhere I would be ok with that.
Support came back with this documentation:
They say that it says that backups of system databases are Microsoft's responsibility.