Veritas NetBackup 7.7 features: What is and how to use SQL Intelligent Policy (SIP)?

By | August 24, 2015

NetBackup 7.7 is already out and it's time to share some details of new features. In this post we discuss the following topics:

  1. What is SQL Intelligent Policy?
  2. How to configure/use this kind of policy?
  3. Current limitations of SQL Intelligent Policy.

NetBackup SQL Intelligent Policy Overview

Up to NetBackup 7.6.x, the backup admins have to create SQL batch file manually (really annoying) to backup SQL databases by NetBackup. As I mentioned here, NetBackup 7.7 comes with SQL Intelligent Policy helping to create batch file automatically  to backup SQL databases. Maybe you use Oracle Intelligent Policy already? 😉 (available from NetBackup 7.6)

NetBackup SQL Intelligent Policy Usage

The SQL Intelligent Policy configuration consists two parts:

  • Registering the SQL instance (or instance group) with credentials.
  • Creating the SQL policy to specify backup selections.
  1. To protect an instance group or SQL Server instance with a SQL Server Intelligent
    Policy, you must register the instance with credentials. Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP
  2. Enter the instance and host name. Click OK. Then you can define credentials.
    Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 3Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 2
  3. The SQL instance has been added.Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 4
  4. Now we need to create MS-SQL-Server policy. Select Policy storage etc. Then click Schedules tab.Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 5
  5. As you can see on the below figure, there are not Application/Automatic type of backup! 🙂Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 6
  6. Click the Instances and Databases tab. There are three options: Protect instances (1), Protect instances groups (2) or Clients for use with batch files (3). Then click New (4).Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 7
  7. Select Instance and click OK.Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 8
  8. The instance has been added to the list. Click Backup Selections tab.Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 10
  9. Now we can choose the SQL Server object types to protect. There are three options: Whole database, Filegroups, Files.Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 11
  10. I have chosen Whole database. Click the Microsoft SQL Server tab.Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 13
  11. This is the tab where you can specify database options such number of backup stripes, block size etc. At last by GUI! we do not need to add required options to the batch file! Veritas NetBackup 7.7 features: SQL Intelligent Policy SIP 14
  12. That's all. Now you can run the policy.

For more information please follow NetBackup guide for SQL.

NetBackup SQL Intelligent Policy limitations

There are some limitations of SQL Intelligent Policy in NetBackup 7.7 as follows:

  • No Microsoft SQL Cluster or Always On support.
  • The restore process is practically the same as in earlier NetBackup. For more information please follow post How to restore Microsoft SQL databases using NetBackup.
  • Not possible to exclude database from backup easly (e.g. you have 100 databases and you want to exclude only one).

Conclusion

The NetBackup SQL Intelligent Policy is a good step to help NetBackup Admins configuring SQL protection. To be honest still I have been waiting for easier restore process of SQL during Disaster Recovery. Who know, maybe this is addressed on the road map...

3 thoughts on “Veritas NetBackup 7.7 features: What is and how to use SQL Intelligent Policy (SIP)?

  1. Andreas Bechter

    Hi Mariusz,

    excellent article. Here´s great news for you:

    MS SQL Always On, Part 1 is now in NetBackup 7.7.1.
    The link to the release notes: https://download.veritas.com/resources/content/live/SFDC/77000/000076639/en_US/NetBackup771_RelNotes_ver2.pdf?__gda__=1448144024_9267be50f5b4e0ab142e7d701894dc7d

    NetBackup for SQL Server
    Support for AlwaysOn Availability Groups
    NetBackup 7.7.1 adds support for AlwaysOn Availability Groups (AGs) with policies that use the option “Clients for use with batch files.” NetBackup does not support AGs with SQL Server Intelligent Policy at this time.

    regards,
    Andreas Bechter
    Regional Product Manager EMEA, Backup & Recovery
    Veritas

    Reply
    1. Mariusz Post author

      Hi Andreas,

      I can't find any great news 🙂 The SQL Intelligent Policy is still not supported for Always On Availability Groups.

      Reply

Leave a Reply to saminathan Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.