Comvault Backups breaking the backup chain?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 10, 2015 at 10:27 am

  #294187

  I'm performing SQL Server native backups and Comvault Backups are breaking the backup chain?

  I can work around them if they only perfume 1 backup per day.

  We have a 3rd party hosting our servers so I do not have much control as to what they do.

  I have concerns about being able to get my databases Comvault being restored.

  Any input would be greatly appreciated.

  Thanks.:-)

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  January 10, 2015 at 10:56 am

  #1769244

  Welsh Corgi (1/10/2015)

  ---

  I'm performing SQL Server native backups and Comvault Backups are breaking the backup chain?

  I can work around them if they only perfume 1 backup per day.

  We have a 3rd party hosting our servers so I do not have much control as to what they do.

  I have concerns about being able to get my databases Comvault being restored.

  Any input would be greatly appreciated.

  Thanks.:-)

  I'm going through the same hooie for a client. The 3rd Party Host had setup full backups once per week and log file backups once per day. I had to beat them with a proverbial bat to get them to change to full backups every night and more frequent log file backups. They wouldn't go any lower than once every 4 hours and they said "best practices" say you don't have to. Obviously, they don't have a clue. They also said that if we do our own backups that they would not be responsible for helping in any way if a DR situation came about and we couldn't use the "free" diskspace that they normally overcharge for and we'd still have to pay for that.

  And, where I normally test a restore for the "money maker" database every night, they only do one once every 6 months or so and you have to remind them to do it.

  The purpose of me telling you all of that is that you need to work with the 3rd Party Hosts (our didn't even have an SQL Server DBA in the employ until just several months ago) and it's going to be like pulling teeth on the pig that you're trying to teach to fly. And, you need to know if you're voiding any kind of support if you're doing your own backups.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Grant Fritchey

  SSC Guru

  Points: 399289

  More actions

  January 11, 2015 at 6:02 am

  #1769291

  100% agreement with all that Jeff said.

  One question. If you're not doing differential backups, is it any big deal that they have an extra full backup going on?

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning