cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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.

 

 

2 Solutions

Accepted Solutions
Highlighted
Accepted Solution!

Re: Netbackup SQL intelligent policy implementation

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

Highlighted
Accepted Solution!

Re: Netbackup SQL intelligent policy implementation

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
Highlighted
Accepted Solution!

Re: Netbackup SQL intelligent policy implementation

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

Highlighted
Accepted Solution!

Re: Netbackup SQL intelligent policy implementation

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