System Database Backups for Azure SQL Managed Instance

Chancellor, Joe 0 Reputation points
2024-06-21T20:35:16.1766667+00:00

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

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,337 questions
{count} votes

2 answers

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,381 Reputation points Microsoft Employee
    2024-07-08T03:43:21.16+00:00

    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


  2. Chancellor, Joe 0 Reputation points
    2024-07-13T00:10:36.53+00:00

    Support came back with this documentation:

    https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql#administration-features

    They say that it says that backups of system databases are Microsoft's responsibility.

    0 comments No comments