Forum Discussion

perez_cmz's avatar
perez_cmz
Level 6
7 years ago

SQL backup for new Win2012 client failing (none of the requested files were backed up - 2)

I have clients with identical specs backing up successfully. These are the details for the last failed job 08/30/2017 10:08:08 - Info nbjm (pid=9633) starting backup job (jobid=245727589) for client...
7.7
UNIX
  • perez_cmz's avatar
    perez_cmz
    7 years ago

    Found the issue

    For some reason, this particular bch file was missing "SQLINSTANCE $ALL"

    Once I added this line into the bch file, the backup ran and completed successfully

perez_cmz's avatar
perez_cmz
Level 6
7 years ago

Yes, I am able to connect on NetBackup MS SQL Client and see the SQL instances.

The Netbackup services use a "local system account"

  • Thiago_Ribeiro's avatar
    Thiago_Ribeiro
    Moderator
    7 years ago

    Hi,

    Are you using SQL Intelligent Policy or Legacy configuration? Can you check this information about Local System acconunt?

    NetBackup uses the NetBackup Client Service and the NetBackup Legacy Network Service to access the SQL Server when it performs backups and restores. With the proper configuration, these services can log on with the Local System account or another account that has the necessary privileges.

    The logon account for the services requires the following:

    • Both services must use the same logon account.
    • The SQL Server “sysadmin” role.
    • If you want to use Local System for the logon account, the requirements depend on the SQL Server version:
    • For SQL Server 2008, the sysadmin role is automatically applied to the NT AUTHORITY\SYSTEM and BUILTIN\Administrators groups.
    • For SQL Server 2012 and later, you must first apply the sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group.
    • For a SQL Server cluster or SQL Server availability group (AG), configure the NetBackup services on each node in the cluster or AG.
    • For VMware backups, different configuration is required for logon account for the services.

    For more informations about NetBackup services see  https://www.veritas.com/support/en_US/article.000029885

     

    Regards,

     

    Thiago

  • Marianne's avatar
    Marianne
    Level 6
    7 years ago
    When the SQL dba runs the backup from the SQL client, they login with sufficient SQL rights. Right?

    Ask the dba to change NBU Client service account to a SQL account with sufficient rights. Preferrably same service account as SQL services.
    • perez_cmz's avatar
      perez_cmz
      Level 6
      7 years ago

      Found the issue

      For some reason, this particular bch file was missing "SQLINSTANCE $ALL"

      Once I added this line into the bch file, the backup ran and completed successfully

      • Thiago_Ribeiro's avatar
        Thiago_Ribeiro
        Moderator
        7 years ago

        Hi,

        Is it possible that someone has changed this .bch script? Did you check the last changed?