01-09-2019 12:33 AM
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!
Solved! Go to Solution.
01-09-2019 04:06 AM - edited 01-09-2019 04:08 AM
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
01-09-2019 04:06 AM - edited 01-09-2019 04:08 AM
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
03-13-2019 07:55 PM
Hi Ma'am @Marianne, thank you so much!
Best regards!