Forum Discussion

EHasani's avatar
EHasani
Level 1
7 years ago

Re: SQL Backup error

**** Moved to new discussion from https://vox.veritas.com/t5/NetBackup/SQL-Backup-error/m-p/764653  ****    Hi Marianne I have the same issue. I use administrator account on netbackup client se...
Marianne's avatar
Marianne
Level 6
7 years ago

Hi EHasani

Can we please start fresh where you tell us more about your environment and the error you are getting? 

Which NBU version? 
Are you using traditional script-based policy or Intelligent policy?

The error in the original post was :
Error: Failed to query database metadata for <test>

If same/similar error, please ensure that dbclient log folder exists on the SQL client (logging level 3 should be fine).

dbclient log will show the username that is used for the backup and what the access/authentication issue is.

NBU Client Service account needs more than just Administrator priveleges - it also needs SQL dba priveleges.
Always good to start NBU Client services with same logon account as SQL services. 

See this TN:

NetBackup for Microsoft SQL Server database agent: What permissions are required for the backup and restore of Microsoft SQL Server databases?

https://www.veritas.com/support/en_US/article.100017184

  • NBU35's avatar
    NBU35
    Level 6
    7 years ago

    Hi 

    SUch type of issue generally happen when your account does not have appropriate privileges.

    Please try as follows:

    Get that user added to BULITINADMIN group on server hosting SQL DB.

    Also in SQL provide same user sysadmin privileges.

    Then in service.msc, add same account to manage NetBackup Client Service & NetBackup Legacy Network service.

    then restart netbackup services and retry your backup.