Forum Discussion

a04andno's avatar
a04andno
Level 3
7 years ago

MSSQL AG netbackup restore warning: Unable to obtain list of files using specified search criteria.

Hi, My name is Anders and I am working on migrating our old database setup to a new one and going from SQL server 2008 R2 with database mirroring to 2016 with AGs. Unfortunately I have some problems...
7.7
Windows Server 2016
  • Michael_G_Ander's avatar
    Michael_G_Ander
    7 years ago

    Please look at the restore section in the manual, what you have posted is the backup setup section.

    Start the Netbackup MS SQL Client to do the SQL restores, not the Backup, Archive and Restore GUI.

     

Michael_G_Ander's avatar
Michael_G_Ander
Level 6
7 years ago

Think there is some confusion here, you need to use the NetBackup SQL Agent GUI to restore SQL databases as far as I know.

Have not worked with AG, but assume the restore procedure is described in the Netbackup SQL Admin guide.

 

  • a04andno's avatar
    a04andno
    Level 3
    7 years ago

    Hi Michael_G_Ander and thank you for answering. As I mentioned I have tried to restore from the client but no backups are found at all after a successful backup. According to the manual it should work with the code "preferredreplica true" in front of every backup command in the batch script when dealing with AGs. I also have created the policy with the two AG clients in the WSFC on the netbackup server. I have read the manual a lot and cant see anything I missed and I have also searched this forum and the Internet for answers. Now I  have created a "altnames" directory with a empty No.Restrictions file but that was also in vein. One theory I have is that the client dont find anything because the backup is under "mssqlcluster" and not under the secondary sql nodename (mssql3.hs.local)? As you can see from my previous mail the backup is put in a mssqlcluster.hs.local directory during the process. But as I said I have followed the manuals when I did the setup so it should work.

    Regards Anders

     

     

    These are the steps from the manual I have followed.

    • Michael_G_Ander's avatar
      Michael_G_Ander
      Level 6
      7 years ago

      Please look at the restore section in the manual, what you have posted is the backup setup section.

      Start the Netbackup MS SQL Client to do the SQL restores, not the Backup, Archive and Restore GUI.

       

      • a04andno's avatar
        a04andno
        Level 3
        7 years ago

        Thank you guys for your help. It works when I use the client and put the cluster name as the source client, previously I also put the SQL-host there. So now it seems to work fine with my legacy created batch policys.

        Regards Anders