SQL Backup retries

[H_Sharma]

Hello Experts,

We have some SQL policies and some instacnces get fail in the stream like MASTER, MSBD, MODEL etc and rest of the database backups get successfull.

Do we need to refire these again?

Thanks,

[Marianne]

You need master db backup to be successful in order to recover SQL instance in case of DR. Not sure if the others are needed. Best to look at dbclient log to see why backup is failing. If this is transaction log backup, then those and other db's in simple recovery mode must be excluded.

[Suchet_Siddu_J_ · Accepted solution]

Please check DB permission and include below keywords in .bch script .

NUMRETRIES  Integer value from 1 to 9  and RESTARTTYPE  to  AUTO.

NUMRETRIES  - retries the failed job. if the job keeps failing check dbclient logs.