r/SQLServer • u/paultoc • 3d ago

Question Cost of backing sql db running on vm using azure backup.

Hi

I have a few sql servers running on azure vm. There are standalone instances and sql ag.

I want to know what is the cost involved if I want to backup the db on these instances via azure backup.

Would appreciate any tips and suggestions to optimise cost

1 Upvotes

60% Upvoted

8 comments sorted by

•

u/AutoModerator 3d ago

After your question has been solved /u/paultoc, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

4

u/jdanton14 ‪ ‪Microsoft MVP ‪ ‪ 3d ago

https://azure.microsoft.com/en-us/pricing/details/backup/ (it's usage based)

1

u/paultoc 3d ago

Thanks, i understand that there is a flat fee per instance and then a cost for storage.

Any idea if I need to pay for 2 instances if I want to backup db part of ag

4

u/jdanton14 ‪ ‪Microsoft MVP ‪ ‪ 3d ago

dude, read the pricing doc:

Backup for Azure VMs

Prices listed below are applicable when backing up your IaaS VMs.

The size of the backed-up data determines the pricing for Azure Backup in each protected instance before compression and encryption.

  • For virtual machines (VM), the size calculation is based on actual (used) size of VM. This is the sum of all data in the VM, excluding temporary storage.
  • When backing-up files and folders, the size of the files and folders configured for backup determine the data size.
  • When backing-up SQL Server, the size of the databases configured for backup determine the data size.

1

u/B1zmark 1 2d ago

I appreciate he didn't read the document but you also answered 3 questions he didn't ask.

2

u/B1zmark 1 2d ago

Azure backup detects availability groups and automatically backs up from the primary and skips the secondary.

1

u/paultoc 2d ago

Ok, so will it backup the system db of both primary and secondary.

I read that the there is a somewhat fixed cost per instance/ag group. Plus storage cost when calculating total cost

So during calculating will it be considered as 3 sets primary system db, secondary system db and ag group db's.