Forum Discussion

Npalma's avatar
Npalma
Level 4
7 years ago
Solved

How restore SQL database to different server in cluste HA

Hello,
how the configuration is done to solve a database in a different SQL windows 2016 server.

8
Linux
  • Marianne's avatar
    Marianne
    7 years ago

    Npalma 

    The Client name that you specify for restore needs to match the Client name in the policy EXACTLY.
    All of this is explained very well in the manual.

    Before you try to run the restore, please check if you can list SQL backups from the destination client using bplist command :

    install_path\NetBackup\bin\bplist -C client -t 15 -R \

    Also - the 'altnames' file should be No.Restrictions.

     

9 Replies

Sort By
  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    Moderator
    7 years ago

    Hello,

    the question is a bit vague. Describe type+configuration of the cluster and what do you want to achieve.

    Michal

    • Npalma's avatar
      Npalma
      Level 4
      7 years ago

      Thanks for answering, apply the indicated but I have an error. I have a VIP ip between two SQL Server servers in HA cluster. I create a policy of protect instances for virutal IP and makes the backup. The problem is presented to restore mindicates the following error:

      "no backup sql server object were found for client in the specified timeframe"

      I have created the file "/usr/openv/netbackup/db/altnames/No.Restrictio" on my master server to allow recovery from any hosts.

      • Marianne's avatar
        Marianne
        Level 6
        7 years ago

        Npalma 

        The Client name that you specify for restore needs to match the Client name in the policy EXACTLY.
        All of this is explained very well in the manual.

        Before you try to run the restore, please check if you can list SQL backups from the destination client using bplist command :

        install_path\NetBackup\bin\bplist -C client -t 15 -R \

        Also - the 'altnames' file should be No.Restrictions.