Forum Discussion

rVikas's avatar
rVikas
Level 5
9 years ago

Netbackup SQL intelligent policy implementation

Hi All,

 

I need a help on implementation of SQL intelligent policy.

I would like to know what is the best practice and schedule :

For full and incremental database backups.

for Transaction log backup.

Also does it support configuration of policy for SQL servers in clusters.

 

It will be great if someone can share sample configuration.

 

 

  • Hello,

    RPO (data loss) and RTO (recovery time) should be specified by "data owner", not by backup admin. So consult appropriate person and then scheduling and backup strategy can be set up.

    So there is no "best practise" for these parameters, sometimes RPO = 1 week is enough and sometimes 1hr is not enough.

    Also there is no difference for this if SQL policy is intelligent or script-based.

    For cluster support , server and SQL client must be on NetBackup 7.7.2.

    Regards

    Michal

  • I wrote a post in my blog about configuring SQL IP. It is in Spanish, but i hope google can help translating it:

     

    https://translate.google.es/translate?sl=es&tl=en&js=y&prev=_t&hl=es&ie=UTF-8&u=https%3A%2F%2Fnetbackupguru.es%2Fnetbackup-sql-intelligent-policies%2F&edit-text=&act=url

     

2 Replies

  • I wrote a post in my blog about configuring SQL IP. It is in Spanish, but i hope google can help translating it:

     

    https://translate.google.es/translate?sl=es&tl=en&js=y&prev=_t&hl=es&ie=UTF-8&u=https%3A%2F%2Fnetbackupguru.es%2Fnetbackup-sql-intelligent-policies%2F&edit-text=&act=url

     

  • Hello,

    RPO (data loss) and RTO (recovery time) should be specified by "data owner", not by backup admin. So consult appropriate person and then scheduling and backup strategy can be set up.

    So there is no "best practise" for these parameters, sometimes RPO = 1 week is enough and sometimes 1hr is not enough.

    Also there is no difference for this if SQL policy is intelligent or script-based.

    For cluster support , server and SQL client must be on NetBackup 7.7.2.

    Regards

    Michal