cancel
Showing results for 
Search instead for 
Did you mean: 

none of the requested files were backed up (2)

J_Huggins
Level 6
Partner

Hi all, good day!

Anyone can help me regarding on my issue in Backing up SQL Batch file.

I created test Database and Batch file and the issue persist when I'm going to run the policy in the NBU Master Server.

But when I tried to run the Backup in NBU MSSQL Client the Backup goes successully.

Please see the attached file for the dbclient logs.

Thank you and best regards!

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

The difference is the user account used for the 2 backup methods. 
The user accounts that are used can clearly be seen in the log.

When you logon to the system and perform backup from there, we see this account name:

14:08:34.442 [4000.2380] <4> CDBIniParms::CDBIniParms: INF - NT User is suicidesquid

When you initiate the backup via NBU, the service account for NBU Client Service and Legacy service is used. It appears to be Local System. This account does not have sufficient permissions for SQL 2012: 

13:29:39.727 [3936.3720] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
13:29:39.742 [3936.3720] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <sql2012> on server <sql2012>.
13:29:39.805 [3936.3720] <4> CDBbackrec::CDBbackrec: INF - Error: Failed to query database metadata for <Test_Database>

You need to change the logon account for the 2 services (mentioned above) to a service account with sufficient permissions. 
See NBU for MS-SQL manual under this topic: 
Configuring the NetBackup services for SQL Server backups and restores

Links to NBU 8.1.2 manuals: 

URL: https://www.veritas.com/support/en_US/article.100044086

View solution in original post

2 REPLIES 2

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

The difference is the user account used for the 2 backup methods. 
The user accounts that are used can clearly be seen in the log.

When you logon to the system and perform backup from there, we see this account name:

14:08:34.442 [4000.2380] <4> CDBIniParms::CDBIniParms: INF - NT User is suicidesquid

When you initiate the backup via NBU, the service account for NBU Client Service and Legacy service is used. It appears to be Local System. This account does not have sufficient permissions for SQL 2012: 

13:29:39.727 [3936.3720] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
13:29:39.742 [3936.3720] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <sql2012> on server <sql2012>.
13:29:39.805 [3936.3720] <4> CDBbackrec::CDBbackrec: INF - Error: Failed to query database metadata for <Test_Database>

You need to change the logon account for the 2 services (mentioned above) to a service account with sufficient permissions. 
See NBU for MS-SQL manual under this topic: 
Configuring the NetBackup services for SQL Server backups and restores

Links to NBU 8.1.2 manuals: 

URL: https://www.veritas.com/support/en_US/article.100044086

Hi Ma'am @Marianne, thank you so much!

Best regards!