Backup verify with third party tools

Question

Backup verify with third party tools

ramana3327

SSCoach

Points: 19722
More actions
April 17, 2022 at 9:16 pm

#4017668

Is backup verify option available with third party tools (DDBoost or Lite speed or Redgate) like native backup in sql? What are the negative impact using backups with verify option?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27055 More actions · Answer 1

ramana3327 wrote:

Is backup verify option available with third party tools (DDBoost or Lite speed or Redgate) like native backup in sql? What are the negative impact using backups with verify option?

All of them, I think, have the option to verify the backup file.

I don't think that there are any negatives to doing this. Depending upon how your backups are configured, it will make the backups take longer. So, instead of backup/verify, backup/verify, backup/verify, you may want to do all of the backups, and then verify all of the backups.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

ramana3327 SSCoach Points: 19722 More actions · Answer 2

Thank you. What will happen if the backup verify fail in one of the database? It will start again taking the backup or just tell us the verify option failed

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 3

ramana3327 wrote:

Thank you. What will happen if the backup verify fail in one of the database? It will start again taking the backup or just tell us the verify option failed

"It Depends!!!"

I strongly recommend you read the article at the following link and also follow many of the links that article contains for this very important subject. 😉

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/possible-media-errors-during-backup-and-restore-sql-server

I also strongly recommend that you snuggle up with a copy of the documentation that the 3rd party tool provides and read about such things.

--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)