question

MauriceFaraj-9184 avatar image
0 Votes"
MauriceFaraj-9184 asked MauriceFaraj-9184 answered

azure managed instance backup

we have subscription with azure managed instance. just i need to be confirmed and relax that backup of mssql database and power apps applications are backup by default since from my side i have create acy backup job or schedule.
please advise
Thanks,

azure-sql-databaseazure-sql-virtual-machines
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.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

You have automated backups for Azure Managed Instance. That is a benefit of having databases on PaaS, 35 days retention period for automated backups.



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.

GeethaThatipatri-MSFT avatar image
0 Votes"
GeethaThatipatri-MSFT answered GeethaThatipatri-MSFT commented

Hi @MauriceFaraj-9184 Welcome to the Microsoft Q&A forum, and thanks for reaching out.
SQL PaaS handles the backups, you cannot set the schedule. If you need a backup at a specific time the only option you have is in SQL MI you can perform a COPY ONLY full backup to storage.


Regards
Geetha

· 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.

@GeethaThatipatri-MSFT please make this an answer.

0 Votes 0 ·

Sure @AlbertoMorillo Thank you.

Regards
Geetha

0 Votes 0 ·
MauriceFaraj-9184 avatar image
0 Votes"
MauriceFaraj-9184 answered

when i go to backup center in azure portal, it is showing me
0 completed
i can not see anything that shows me that backup has been done successfuly, that is why i am asking you to do it myself.
we had subscribed in azure managed instance to avoid the mission
to do backup as database administrator.
please advise
Thanks,

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.

MauriceFaraj-9184 avatar image
0 Votes"
MauriceFaraj-9184 answered

please have a look at screenshot219081-screenshot-of-portal-azure-backup-center.png



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.