Veritas -- NetBackup 7.7

• cheshirefox

  Hall of Fame

  Points: 3464

  More actions

  December 15, 2015 at 11:42 am

  #306332

  Hi -

  I have a volatile OLTP environment on SQL 2014 ENT. I backup the tran log every 15 - the average size of the tran log backup is 82 GB (20.5 GB compressed). I have AlwaysOn configured (async).

  We're performing a POC with Veritas NetBackup. For the POC, we need to move to weekly full backups, differential backups every XX hours and continue the transaction log every 15 minutes.

  Top of mind concerns:

  Currently it takes 5 hours to backup the full databases (to local Flash storage). Veritas wants us to write all the backups to the Veritas on-premise appliance. I'm concerned about the transaction log due to always on and not being able to truncate it during the course of the backup.

  Veritas agent that runs on the SQL cluster. CPU consumption, etc...

  So - my question - who is running AlwaysOn with Veritas?

  Anyone running this type of environment with this type of thru put?

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  December 17, 2015 at 5:33 am

  #1846525

  Don't use non-native backups for SQL. This is always a bad idea. These products will always fail you in the end.

  If it takes you that long to backup your DB then you need to tune your backup. I've got a session where I teach you how to do that.

  http://midnightdba.itbookworm.com/EventVids/SQLSAT90BackupTuning/SQLSAT90BackupTuning.wmv

  As well, I have a beautiful backup routine I've written and it's extremely rich. You can download it below. And it's FREE.

  But those 3rd party backups apps are never a good idea.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: