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

%3CLINGO-SUB%20id%3D%22lingo-sub-1673090%22%20slang%3D%22en-US%22%3EIs%20it%20ok%20to%20take%20SQL%20Database%20backup%20using%20SQL%20Server%20in%20Azure%20VM%20and%20SQL%20Server%20maintenance%20plan%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1673090%22%20slang%3D%22en-US%22%3E%3CP%3ECurrently%2C%20we%20are%20taking%20SQL%20Database%20backup%20using%20%22Recovery%20Services%20Vault%20-%20SQL%20Server%20in%20Azure%20VM%22%20Daily%20full%20backup%20at%208.00%20PM%2C%20HourlyLogBackup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20that%2C%20can%20we%20create%20a%20maintenance%20plan%20on%20SQL%20Server%20to%20take%20Database%20backup%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWeekly%20full%20backup%20on%20Fridays%20at%2012.00%20PM%2C%20Daily%20Differential%20backups.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20we%20take%20backups%20using%20different%20backup%20software%2C%20I%20know%20the%20backup%20chain%20will%20be%20broken.%20I%20really%20appreciate%20any%20help%20you%20can%20provide.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1674109%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20ok%20to%20take%20SQL%20Database%20backup%20using%20SQL%20Server%20in%20Azure%20VM%20and%20SQL%20Server%20maintenance%20pla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1674109%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F172390%22%20target%3D%22_blank%22%3E%40RAJAKUMAR%20SELVARAJ%3C%2FA%3E%26nbsp%3BI%20didn't%20quite%20get%20you%20comment%20about%20the%20broken%20chain%20of%20backups.%20However%2C%20from%20what%20I%20see%20you're%20doing%20it%20right.%20In%20general%2C%20it%20all%20depends%20on%20your%20%3CSTRONG%3E'data%20backup%20and%20retention%20policy'%20and%20the%20values%20you%20set%20for%20RPO%2FRTO%3C%2FSTRONG%3E.%20The%20rule%20of%20thumb%20concerning%20the%20backups%20(and%20this%20is%20how%20the%20managed%20SQL%20does%20it%2C%20btw)%3A%3C%2FP%3E%3CUL%3E%3CLI%3EFull%20backup%20(full%20database%20backups%20are%20created%20weekly)%3C%2FLI%3E%3CLI%3EDifferential%20backup%20(differential%20backups%20are%20created%20every%2012%20hours)%3C%2FLI%3E%3CLI%3ETransaction%20log%20backup%20(transaction%20log%20backups%20are%20created%20every%2010%20minutes)%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
New Contributor

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 maintenance plan on SQL Server to take Database backup?

 

Weekly full backup on Fridays at 12.00 PM, Daily Differential backups.

 

When we take backups using different backup software, I know the backup chain will be broken. I really appreciate any help you can provide.

2 Replies

@RAJAKUMAR SELVARAJ 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)

@RAJAKUMAR SELVARAJ 

 

Hi it's not bad idea but what would be the benefit of that ?That can  lead to management overhead . The best way is to define your RPO RTO and align your backup policy to those aspects . If the purpose is to save costs i would suggest to compare scenarios using pricing calculator and  rely on automation taks .