β02-10-2016 09:49 PM
**Actually I'm running a virtual Windows Server 2012, X64bit on VMWare.**
**Netbackup Ver 7.6.1.2
**Database backup
==========================
Hi all.
I'm getting this error mesesage of "- Info dbclient(pid=14196) ERR - Error in GetConfiguration: 0x80770003". It's backing up of my database running on a VM Windows Server 2012 X64bit. Do advise, thanks.
================================================================
30/01/2016 4:48:41 PM - Info bpbrm(pid=24296) sgctrvsql02 is the host to backup data from
30/01/2016 4:48:41 PM - Info bpbrm(pid=24296) reading file list for client
30/01/2016 4:48:42 PM - Info bpbrm(pid=24296) starting bphdb on client
30/01/2016 4:48:42 PM - Info bphdb(pid=8240) Backup started
30/01/2016 4:59:37 PM - Error bpbrm(pid=24296) from client sgctrvsql02: ERR - command failed: none of the requested files were backed up (2)
30/01/2016 4:59:37 PM - Error bpbrm(pid=24296) from client sgctrvsql02: ERR - bphdb exit status = 2: none of the requested files were backed up
30/01/2016 4:59:38 PM - Info bphdb(pid=8240) done. status: 2: none of the requested files were backed up
30/01/2016 5:51:00 PM - Info nbjm(pid=6912) starting backup job (jobid=370372) for client sgctrvsql02, policy W_SQL-VSQL02-NBA, schedule Wk_VSQL02
30/01/2016 5:51:00 PM - Info nbjm(pid=6912) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=370372, request id:{C0984873-D350-45F7-A329-F09EDB93B12E})
30/01/2016 5:51:00 PM - requesting resource stu_disk_sgctrvl002
30/01/2016 5:51:00 PM - requesting resource sgctrbu001.NBU_CLIENT.MAXJOBS.sgctrvsql02
30/01/2016 5:51:00 PM - requesting resource sgctrbu001.NBU_POLICY.MAXJOBS.W_SQL-VSQL02-NBA
30/01/2016 5:51:00 PM - granted resource sgctrbu001.NBU_CLIENT.MAXJOBS.sgctrvsql02
30/01/2016 5:51:00 PM - granted resource sgctrbu001.NBU_POLICY.MAXJOBS.W_SQL-VSQL02-NBA
30/01/2016 5:51:00 PM - granted resource stu_disk_sgctrvl002
30/01/2016 5:51:00 PM - estimated 0 Kbytes needed
30/01/2016 5:51:00 PM - Info nbjm(pid=6912) started backup (backupid=sgctrvsql02_1454147460) job for client sgctrvsql02, policy W_SQL-VSQL02-NBA, schedule Wk_VSQL02 on storage unit stu_disk_sgctrvl002
30/01/2016 5:51:01 PM - started process bpbrm (24296)
30/01/2016 5:51:02 PM - connecting
30/01/2016 5:51:03 PM - connected; connect time: 0:00:01
30/01/2016 5:51:04 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "imos_prod" under the current security context.>.
30/01/2016 5:51:04 PM - Info dbclient(pid=14196) WARN - Error found executing <select groupname,groupid from "imos_prod"..sysfilegroups order by groupname>.
30/01/2016 5:51:04 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.>.
30/01/2016 5:51:04 PM - Info dbclient(pid=14196) WARN - Error found executing <select groupname,groupid from "model"..sysfilegroups order by groupname>.
30/01/2016 5:51:05 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "ReportServer" under the current security context.>.
30/01/2016 5:51:05 PM - Info dbclient(pid=14196) WARN - Error found executing <select groupname,groupid from "ReportServer"..sysfilegroups order by groupname>.
30/01/2016 5:51:05 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "ReportServerTempDB" under the current security context.>.
30/01/2016 5:51:05 PM - Info dbclient(pid=14196) WARN - Error found executing <select groupname,groupid from "ReportServerTempDB"..sysfilegroups order by groupname>.
30/01/2016 5:51:09 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "imos_prod" under the current security context.>.
30/01/2016 5:51:09 PM - Info dbclient(pid=14196) ERR - Error found executing <use "imos_prod">.
30/01/2016 5:51:09 PM - Info dbclient(pid=14196) ERR - Unable to determine FILESTREAM paths for database imos_prod.
30/01/2016 5:51:09 PM - Info dbclient(pid=14196) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 4(4) seconds.
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) INF - BACKUP STARTED USING
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) May 14 2014 18:34:29
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) Copyright (c) Microsoft Corporation
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) Batch = C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch, Op# = 2
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) INF - Using backup image SGCTRVSQL02.MSSQL7.SGCTRVSQL02.db.master.~.7.001of001.20160130175112..C
30/01/2016 5:51:13 PM - Info dbclient(pid=14196) INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-14196-14228-1454147474' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
30/01/2016 5:51:14 PM - Info dbclient(pid=14196) INF - Number of stripes: 1, Number of buffers per stripe 2.
30/01/2016 5:51:14 PM - Info dbclient(pid=14196) INF - Created VDI object for SQL Server instance <SGCTRVSQL02>. Connection timeout is <300> seconds.
30/01/2016 5:56:14 PM - Info dbclient(pid=14196) ERR - Error in GetConfiguration: 0x80770003.
30/01/2016 5:56:14 PM - Info dbclient(pid=14196) CONTINUATION: - The api was waiting and the timeout interval had elapsed.
30/01/2016 5:56:14 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <262><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database 'master'.>.
30/01/2016 5:56:14 PM - Info dbclient(pid=14196) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>
30/01/2016 5:56:14 PM - Info dbclient(pid=14196) ERR - Error found executing <backup database "master" to VIRTUAL_DEVICE='VNBU0-14196-14228-1454147474' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
30/01/2016 5:56:16 PM - Info dbclient(pid=14196) INF - OPERATION #2 of batch C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 304(304) seconds.
30/01/2016 5:56:20 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.>.
30/01/2016 5:56:20 PM - Info dbclient(pid=14196) ERR - Error found executing <use "model">.
30/01/2016 5:56:20 PM - Info dbclient(pid=14196) ERR - Unable to determine FILESTREAM paths for database model.
30/01/2016 5:56:20 PM - Info dbclient(pid=14196) INF - OPERATION #3 of batch C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2(2) seconds.
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) INF - BACKUP STARTED USING
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) May 14 2014 18:34:29
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) Copyright (c) Microsoft Corporation
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) Batch = C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch, Op# = 4
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) INF - Using backup image SGCTRVSQL02.MSSQL7.SGCTRVSQL02.db.msdb.~.7.001of001.20160130175623..C
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) INF - backup database "msdb" to VIRTUAL_DEVICE='VNBU0-14196-6168-1454147784' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
30/01/2016 5:56:24 PM - Info dbclient(pid=14196) INF - Number of stripes: 1, Number of buffers per stripe 2.
30/01/2016 5:56:25 PM - Info dbclient(pid=14196) INF - Created VDI object for SQL Server instance <SGCTRVSQL02>. Connection timeout is <300> seconds.
30/01/2016 6:01:25 PM - Info dbclient(pid=14196) ERR - Error in GetConfiguration: 0x80770003.
30/01/2016 6:01:25 PM - Info dbclient(pid=14196) CONTINUATION: - The api was waiting and the timeout interval had elapsed.
30/01/2016 6:01:25 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <262><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database 'msdb'.>.
30/01/2016 6:01:25 PM - Info dbclient(pid=14196) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>
30/01/2016 6:01:25 PM - Info dbclient(pid=14196) ERR - Error found executing <backup database "msdb" to VIRTUAL_DEVICE='VNBU0-14196-6168-1454147784' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
30/01/2016 6:01:27 PM - Info dbclient(pid=14196) INF - OPERATION #4 of batch C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 304(304) seconds.
30/01/2016 6:01:31 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "ReportServer" under the current security context.>.
30/01/2016 6:01:31 PM - Info dbclient(pid=14196) ERR - Error found executing <use "ReportServer">.
30/01/2016 6:01:31 PM - Info dbclient(pid=14196) ERR - Unable to determine FILESTREAM paths for database ReportServer.
30/01/2016 6:01:31 PM - Info dbclient(pid=14196) INF - OPERATION #5 of batch C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2(2) seconds.
30/01/2016 6:01:35 PM - Info dbclient(pid=14196) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "ReportServerTempDB" under the current security context.>.
30/01/2016 6:01:35 PM - Info dbclient(pid=14196) ERR - Error found executing <use "ReportServerTempDB">.
30/01/2016 6:01:35 PM - Info dbclient(pid=14196) ERR - Unable to determine FILESTREAM paths for database ReportServerTempDB.
30/01/2016 6:01:35 PM - Info dbclient(pid=14196) INF - OPERATION #6 of batch C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 2(2) seconds.
30/01/2016 6:01:37 PM - Info dbclient(pid=14196) INF - Results of executing <C:\Program Files\Veritas\NetBackup\scripts\MSSQL\W_MSSQL-VSQL02-ALL-DB-NBA.bch>:
30/01/2016 6:01:37 PM - Info dbclient(pid=14196) <0> operations succeeded. <6> operations failed.
30/01/2016 6:01:37 PM - Info dbclient(pid=14196) INF - The following object(s) were not backed up successfully.
30/01/2016 6:01:37 PM - Info dbclient(pid=14196) INF - imos_prod
30/01/2016 6:01:38 PM - Info dbclient(pid=14196) INF - master
30/01/2016 6:01:38 PM - Info dbclient(pid=14196) INF - model
30/01/2016 6:01:38 PM - Info dbclient(pid=14196) INF - msdb
30/01/2016 6:01:38 PM - Info dbclient(pid=14196) INF - ReportServer
30/01/2016 6:01:38 PM - Info dbclient(pid=14196) INF - ReportServerTempDB
30/01/2016 6:01:59 PM - end writing
none of the requested files were backed up (2)
================================================================
β02-12-2016 12:32 AM
Please verify account you are using for SQL backups has privilages of "bulitin administrator group" on windows & "SYSADMIN" privilages in MSSQL,
Also start Netbackup client services & legacy Network services on your DB client with this use..
β02-12-2016 12:37 AM
In SImple words:
For SQL Server 2012, you must first apply the sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group. Then you can use Local System for the logon accounts for the NetBackup services.
Please refer to https://www.veritas.com/support/en_US/article.HOWTO85432
β02-15-2016 12:19 AM
Always best to change logon account for NBU Client Service to SQL user account and not leave it as LocalSystem.
PS:
I have moved this post to NetBackup forum as this is not related not NetBackup Appliances.