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-2049489%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-2049489%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%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20it's%20not%20bad%20idea%20but%20what%20would%20be%20the%20benefit%20of%20that%26nbsp%3B%3FThat%20can%26nbsp%3B%20lead%20to%20management%20overhead%20.%20The%20best%20way%20is%20to%20define%20your%20RPO%20RTO%20and%20align%20your%20backup%20policy%20to%20those%20aspects%20.%20If%20the%20purpose%20is%20to%20save%20costs%20i%20would%20suggest%20to%20compare%20scenarios%20using%20pricing%20calculator%20and%26nbsp%3B%20rely%20on%20automation%20taks%20.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 .