Forum Discussion

SRAJAKUMARM365AZURE's avatar
SRAJAKUMARM365AZURE
Copper Contributor
Sep 16, 2020

Is it ok to take SQL Database backup using SQL Server in Azure VM and SQL Server maintenance plan?

Currently, we are taking SQL Database backup using "Recovery Services Vault - SQL Server in Azure VM" Daily full backup at 8.00 PM, HourlyLogBackup.   In addition to that, can we create a maintenan...
Command0r's avatar
Command0r
Iron Contributor
Sep 16, 2020

SRAJAKUMARM365AZURE I didn't quite get you comment about the broken chain of backups. However, from what I see you're doing it right. In general, it all depends on your 'data backup and retention policy' and the values you set for RPO/RTO. The rule of thumb concerning the backups (and this is how the managed SQL does it, btw):

  • Full backup (full database backups are created weekly)
  • Differential backup (differential backups are created every 12 hours)
  • Transaction log backup (transaction log backups are created every 10 minutes)

Resources