Comprehensive data protection for all workloads
Post Reply
JTT
Service Provider
Posts: 116
Liked: 5 times
Joined: Jan 02, 2017 7:31 am
Full Name: JTT
Contact:

Backup space estimate for SQL server VM

Post by JTT »

Hi!

I am having a hard time to calculate some backup space estimate for SQL server VM in Hyper-V.
Total size for VM itself is around 3TB, there are couple of SQL instances inside and most of SQL databases (total of ~60) are also needed to do regular SQL log backup.
Currently with another backup software, there are kept 30 restore points, log backup is done with an interval of 2 hours and one full backup by daily.

Can anybody give me some guidance, how to estimate the backup space needed for this VM?
PTide
Product Manager
Posts: 6551
Liked: 765 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup space estimate for SQL server VM

Post by PTide »

Hi,

Our fellow engineer has created this tool which can give you some estimate on how much space the backup will take.
Space required for logs per day can be roughly weighted if you know how much of transaction log the VM produces in 2 hours (12 two-hour intervals x N MB of logs).

Thanks!
Post Reply

Who is online

Users browsing this forum: Bing [Bot], J2E1, juraj.zuziak, musicwallaby, Semrush [Bot], tyler.jurgens and 146 guests