Forum Discussion

sa2's avatar
sa2
Level 4
8 years ago
Solved

backup sql cluster using vip

i have a windows cluster consist of 2 nodes 
the 2 nodes holding SQL database  instances cluster "active - passive " 

i have 3 instances on the cluster " each have it is own "  virtual ip " 
 which is the production ip where the application can communicate with the instance  


the 2 nodes of cluster have a network card dedicated for backup network 
at that moment , we take the backup through the virtual ip of the production which guide the backup master server to the active node holding the instance 


is there any way to configure a vip " Virtual ip for backup " for sql cluster to take the backup through it  

i'm using the script generated by sql agent to backup database then pass it to the policy

 

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    8 years ago

    Just add another IP resource (and NIC if required) to each service group.

  • Thiago_Ribeiro's avatar
    Thiago_Ribeiro
    Moderator
    8 years ago

    Hi,

    There are some steps that I hope can help you to do this. Take a look.

    From Veritas NetBackup for Microsoft SQL Server Administrator's Guide

    About configuration of SQL Server backups with multiple NICs

    Many administrators want to reserve a separate network interface for their SQL Server host machines that are used for routing backup traffic. This type of Chapter 11 configuration requires additional configuration for backup policies and the NetBackup client that backs up SQL Server. Special configuration is also required to perform restores.

    The following distinct network resources exist in a multi-NIC environment:

    ■ The public name of each SQL Server host (for example, sqlhost1 and sqlhost2)

    ■ The private interface name that is used to back up each of the SQL Server hosts (for example, sqlhost1-NB and sqlhost2-NB)

    The following additional resources exist for a SQL Server cluster in a multi-NIC environment:

    ■ The public virtual name of the SQL Server (for example, virtsql)

    ■ The private virtual name of the SQL Server (for example, virtsql-NB)

    The following requirements exist to use NetBackup for SQL Server in a multi-NIC environment:

    ■ Install the NetBackup client on the SQL Server using the private name of the SQL Server host as the NetBackup client name. Alternatively, you can configure the NetBackup client name after installation. See 

    ■ Configure a backup policy that includes the private interface name of the host or client.

    Note that if you want to protect a SQL Server cluster with a legacy SQL Server policy, you must edit the backup batch file. The BROWSECLIENT parameter must indicate the private name of SQL Server host or virtual SQL Server.

    ■ Configure permissions to allow all nodes in the cluster to browse for backups across the private interface (redirected restores). The administrator can allow all clients or allow single clients to browse and restore a backup that is performed over the multi-NIC connection.

    For restore in a multi-NIC environment, refer to the following topics:

    If you want to perform a restore from a SQL Server cluster, you must edit the restore batch file. In the batch file, you must change the BROWSECLIENT parameter to indicate the private name of virtual SQL Server.

     

    Regards,

     

    Thiago