Comprehensive data protection for all workloads
Post Reply
captainflannel
Enthusiast
Posts: 31
Liked: 5 times
Joined: Feb 27, 2012 8:53 pm
Contact:

Backup Mode Suggestions

Post by captainflannel »

Would like some suggestions for a particular scenario running at a site. There are 2 MSSQL Database servers. Roughly 750GB.
SQL1 - 480GB Provisioned, 400GB Used
SQL2 - 335GB Provisioned, 335GB Used
These are tier 1 applications, and they are replicated to a DR site every hour, no big issues there.
Nightly we have to run index reorganize scripts, and weekly index rebuilds. After these scripts we run our VEEAM backup jobs. Currently we have the backup jobs set to Reverse Incremental, and we are running fulls weekly the night after we run the big index rebuilds.
Our nightly reverse incremental jobs run for about 4-6 hours with about 100-200GB of data read
Our weekly full backups run for about 4 hours with about 650GB of data read

Are we running the most optimized backup mode? or would we be better with incremental + synthetic fulls? My main purpose is to decrease the performance hit on our production during the backups, as well as any way to speed restore speeds.

Thanks!
Gostev
Chief Product Officer
Posts: 31796
Liked: 7297 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backup Mode Suggestions

Post by Gostev »

To decrease the performance hit on our production during the backups you should use any incremental backup mode. Incremental backups are generally faster than reversed incremental, so each VM will live less time on snapshot, snapshots will not grow large and snapshot commits will be much faster, thus presenting much less stress on the environments.

If you have not done so yet, I recommend that review the corresponding section of sticky FAQ topic regarding how each backup mode compares to each other, and choose the one that fits you specific needs best.

Thanks!
Post Reply

Who is online

Users browsing this forum: DVashkis, Google [Bot], Gostev and 184 guests