Forum Discussion

H_Sharma's avatar
H_Sharma
Level 6
9 years ago

SQL Backup retries

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,

7.6
Backing Up
Backup and Recovery
Basics
Error messages
NetBackup
Windows Server (2003-2008)
  • Suchet_Siddu_J_'s avatar
    Suchet_Siddu_J_
    9 years ago

    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.

     

2 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    9 years ago
    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_'s avatar
    Suchet_Siddu_J_
    Level 3
    9 years ago

    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.