Im checking several tutorials about how to setup and configure a sql backup to blob, but what Ive found so far are to backup from Sql Server Management Studio.
I did found this nice article at azurelessons:
And when I go to the Backups option on Data Management, it only shows me one that is 7 days old with the following legend: "Azure SQL databases are backed up automatically. Backup availability is listed below for each database on this server. Manage your available long-term retention (LTR) backups or restore a database here."
I have a failover group for the SQL server, but I would also like to have backups performed every 6 hours, and I just cant find the option where to do this, even on the SQL Database.
Thanks for the help.
CodePudding user response:
It looks like you have a managed instance of SQL
Both SQL Database and SQL Managed Instance use SQL Server technology to create full backups every week, differential backups every 12-24 hours, and transaction log backups every 5 to 10 minutes. The frequency of transaction log backups is based on the compute size and the amount of database activity.
When you restore a database, the service determines which full, differential, and transaction log backups need to be restored.
Please check this link: