cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup SQL intelligent policy implementation

rVikas
Level 5
Partner

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.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

EnriquePereira
Level 5
Partner Accredited

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

 

View solution in original post

2 REPLIES 2

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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

EnriquePereira
Level 5
Partner Accredited

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