Forum Discussion

Brian78's avatar
Brian78
Level 3
7 years ago

How to Backup a Two Node Windows SQL Cluster

Hola,  All experts over here, I am newbie when it comes to Netbackup. I want to backup my SQL 2-Node cluster on Windows 2016 Machines. I want to know what exactly i need to do to make sure the backu...
8
NBU 8.1
SQL Server 2016
Windows 2016
Windows Server 2016
  • Marianne's avatar
    Marianne
    7 years ago

    Brian78

    Not sure how else to explain....

    Configuring backups of clustered SQL Server instances (legacy SQL Server policies): https://www.veritas.com/content/support/en_US/doc/17221771-126559330-0/v14764142-126559330 
    uses examples that shows the virtual hostname for SQL on the Production interface - VIRTUALSERVER. Your example: SQLSERVER
    This is the the virtual IP address that is configured in DNS and in the SQL Cluster Resource group and used for 'normal' SQL operations.

    What I was trying to explain, was that an additional IP address is needed on the backup network. :
    Each node should already have a base IP on the backup network (10G), right?
    You now need another virtual IP on the backup network.
    This IP address will need to be defined in DNS and linked to a virtual hostname (SQLSERVER-BK). 
    This virtual IP address also needs to be defined in the same cluster resource group as the SQL instance so that it can fail over along with all other resources in the SQL resource     group. 

    This means that the SQL cluster resource group will have TWO IP resources -
    - one for normal SQL operations on the production network: IP link to SQLSERVER.
    - 2nd IP resource for the backup network: SQLSERVER-BK.

Brian78's avatar
Brian78
Level 3
7 years ago

Hi Maria,

Thanks for responding. I am using RDM so my backup is script based. 

May i know which virtual name i need to choose in the client selections ?

  • Mouse's avatar
    Mouse
    Moderator
    7 years ago

    I think the technote is not being very clear, but I'll try to explain. You may need to have another virtual IP bound to the 10GbE backup interface on top of the access interface/primary virtual IP of the SQL server, this is to make sure NBU will follow the required interface/IP settings. You need to configure also a different hostname in DNS for that IP and use that hostname in the SQL backup script. As the virtual IP will failover along with SQL resources, you should be able to always back up SQL through the backup interface IP.

    • Brian78's avatar
      Brian78
      Level 3
      7 years ago

      Thanks for your reply. The technote doesn't speak about creating a virtual name maybe my DBA should know ill check with and feedback.

      It would be much easier if you have a pictorial representation of how to configure the SQL cluster backup. (Apologies if desire is too much but being new to NBU i really feel that) Sigh... Struggling time :( 

      • Marianne's avatar
        Marianne
        Level 6
        7 years ago
        Brian78
        This is not a SQL 'thing'. Rather networking an cluster config.

        The NBU for SQL manual unfortunately assumes that you would know all of this:
        The 10G interface will have its own virtual IP address (probably base IPs as well for each node). This IP address will need to be defined in DNS and linked to a virtual hostname.
        Furthermore, this virtual IP address will need to be defined in the same cluster resource group as the SQL instance so that it can fail over along with all other resources in the SQL resource group.
        (Not sure about MS terminology. In Veritas Cluster, it is called a Service Group.)