05-19-2016 07:01 AM
Master and client are at 7.7.2
I have created a script for running transaction logs from the client name tranlogs.bch.
tranlogs.bch
OPERATION BACKUP
DATABASE $ALL
EXCLUDE "master"
EXCLUDE "model"
EXCLUDE "msdb"
SQLHOST "serverA"
NBSERVER "masterServer"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
OBJECTTYPE TRXLOG
TRXOPTION TAILLOG
PARTIAL TRUE
NUMBUFS 2
STRIPES 2
POLICY MSSQL_Transaction_Logs
ENDOPER TRUE
I have run as administrator C:\Program Files\Veritas\Netbackup\bin\bpbackex.exe -f tranlogs.bch and <directory>/tranlogs.bch and get a response of 0 operations succeeded, 0 operations failed.
Two policies exist on the Master server
I am starting from the client incase the standard Intelligent policy is not run frequent enough. Where am I going wrong attempting to start from the client?
Solved! Go to Solution.
05-20-2016 05:32 AM
Hello,
it is definitely permission issue, however : remember that SQL Intelligent policies don't allow "Application Backup" schedule types, so you cannot launch SQL backup from the client if you have intelligent policies only. You must have at least one script-based "legacy" MS-SQL-Server policy for this clent if you want achieve this.
Not sure what you mean with "incase the standard Intelligent policy is not run frequent enough". In intelligent policies, you can create Transaction Log Backup schedule type with the frequency up to units of minutes. So create this and let it work according to required frequency, or run it manually.
Also no need to have two policies. Add schedule for Trx Log backups to MSSQL_Intelligent_ServerA policy.
regards
Michal
05-24-2016 12:23 AM
Hello,
two notes:
- when your SQL client is defined between Servers on the Master (Host Properties\Master Server\Servers\Additional Servers), you can perform also admin actions like "remote" Manual Backup with bpbackup -i -p -s, directly from the client (as well as all admin actions, so consider if it is suitable from security perspective for you)
- it is not a good design when you must be constantly afraid of filled disk. Consider larger disk for transaction logs, or change of backup policy (switch to Simple Recovery Model and engage frequent differential backups to maintain required RPO, if point-in-time recovery is not a must. )
Regards
Michal
06-01-2016 01:16 PM
Main problem is
OBJECTTYPE TRXLOG
TRXOPTION TAILLOG
For backups, these cannot be in the same script.
I was able to create a powershell script that runs every minute. If one of the trans logs is approaching 90% full a script is generated and then called with bpbackex.
Thank you everyone for the guidance to get to the solution.
05-19-2016 07:05 AM
MSSQL_Transaction_Logs with Policy type MS-Windows
should be Policy type MS-SQL-Server
05-19-2016 09:44 AM
Updated to MS-SQL-Server. Still getting the same prompt after manually running.
dbbackex
0 operations succeeded, 0 operations failed
05-19-2016 10:01 AM
05-19-2016 11:39 AM
Thank you for the dbclients directory. Yes, I am using a single Policy now with type MS-SQL. A full backup was run successfully (started at the master server [not the client]).
Two things that I am seeing in the included log:
errors logging on to SQL client
and
SQLDataSources did not fetch any ODBC user data source names
I have updated the services on the client (Netbackup Client services and Netbackup Legacy Network Service to run as SQLacct)
I am unable to attach (due to javascript on page) so I am pasting
14:23:31.916 [7812.11120] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:23:31.917 [7812.11120] <2> logconnections: BPRD CONNECT FROM 163.243.51.17.63783 TO 163.243.51.180.1556 fd = 540
14:23:32.075 [7812.11120] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:23:32.076 [7812.11120] <2> logconnections: BPRD CONNECT FROM 163.243.51.17.63784 TO 163.243.51.180.1556 fd = 540
14:23:32.135 [7812.11120] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:23:32.135 [7812.11120] <1> CGlobalInformation::VCSVirtualNameList: CONTINUATION: - The system cannot find the path specified.
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Native Client
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Native Client\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Native Client\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry entry not found for: SOFTWARE\Microsoft\Microsoft SQL Native Client\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server Native Client 10.0
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 10.0\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server Native Client 10.0 is installed on the system
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server Native Client 11.0
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 11.0\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 11.0\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server Native Client 11.0 is installed on the system
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: ODBC Driver 11 for SQL Server
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\MSODBCSQL11\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\ODBC Driver 11 for SQL Server\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry entry not found for: SOFTWARE\Microsoft\MSODBCSQL11\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\DataAccess\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server is installed on the system
14:23:32.137 [7812.11120] <4> getServerName: Read server name from nb_master_config: rdsnbug
14:23:32.138 [7812.11120] <4> CDBIniParms::CDBIniParms: INF - NT User is Mike
14:23:32.165 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:23:32.185 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_1>, SQL userid <SQLacct> handle <0x00649960>.
14:23:32.258 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_1>, SQL userid <SQLacct> handle <0x0064abc0>.
14:23:32.264 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SQLacct'.>.
14:23:32.266 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Failed to connect. Attempting operation with next installed ODBC Driver <SQL Server Native Client 11.0>
14:23:32.278 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_2>, SQL userid <SQLacct> handle <0x0064b610>.
14:23:32.328 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_2>, SQL userid <SQLacct> handle <0x0064c870>.
14:23:32.334 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user SQLacct'.>.
14:23:32.334 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Failed to connect. Attempting operation with next installed ODBC Driver <SQL Server>
14:23:32.345 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0064f2c0>.
14:23:32.396 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x005784a0>.
14:23:32.428 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user SQLacct'.>.
14:23:32.428 [7812.11120] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x005784a0>
14:23:32.649 [7812.11120] <4> CDBbackmain::LoadUserLogin: INF - Creating a read-only DSN for instance <MSSQLSERVER>
14:23:32.649 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Creating an APPLICATION_INTENT=ReadOnly DSN
14:23:32.649 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 11.0>
14:23:32.654 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_4>, SQL userid <SQLacct> handle <0x00579a70>.
14:23:32.661 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_4>, SQL userid <SQLacct> handle <0x0057a210>.
14:23:32.663 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'SQLacct'.>.
14:23:32.664 [7812.11120] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0057a210>
14:23:32.664 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0057a640>.
14:23:32.679 [7812.11120] <4> DBConnect: INF - Failed sql connect try #1
14:23:33.710 [7812.11120] <4> DBConnect: INF - Failed sql connect try #2
14:23:34.742 [7812.11120] <4> DBConnect: INF - Failed sql connect try #3
14:23:35.773 [7812.11120] <4> DBConnect: INF - Failed sql connect try #4
14:23:36.805 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:36.805 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
14:23:36.805 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0057b7c0>.
14:23:36.827 [7812.11120] <4> DBConnect: INF - Failed sql connect try #1
14:23:37.860 [7812.11120] <4> DBConnect: INF - Failed sql connect try #2
14:23:38.891 [7812.11120] <4> DBConnect: INF - Failed sql connect try #3
14:23:39.922 [7812.11120] <4> DBConnect: INF - Failed sql connect try #4
14:23:40.953 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:40.953 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
14:23:40.953 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0057c140>.
14:23:40.983 [7812.11120] <4> DBConnect: INF - Failed sql connect try #1
14:23:42.015 [7812.11120] <4> DBConnect: INF - Failed sql connect try #2
14:23:43.046 [7812.11120] <4> DBConnect: INF - Failed sql connect try #3
14:23:44.078 [7812.11120] <4> DBConnect: INF - Failed sql connect try #4
14:23:45.109 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:45.110 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
14:23:45.110 [7812.11120] <4> CDBbackmain::dbbackup: INF - Results of executing <tranlogs.bch>: <0> operations succeeded. <0> operations failed.
14:24:05.109 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.112 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.115 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.117 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.120 [7812.11120] <4> CGlobalInformation::DSNCleanUp: INF - SQLDataSources did not fetch any ODBC user data source names
05-19-2016 11:49 AM
Yes, I have successfully run a Full SQL backup from the Netbackup master.
Thank you for the information about the dbclient, it is attached below (Javascript is not allowing me to attach)
I am concerned about login line(s)
14:23:36.805 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
Should I be clarifying something for DSN?
I am using the sql account that has access to the database, and that is running the Client Service and Network Service.
14:23:31.916 [7812.11120] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:23:31.917 [7812.11120] <2> logconnections: BPRD CONNECT FROM 163.243.51.17.63783 TO 163.243.51.180.1556 fd = 540
14:23:32.075 [7812.11120] <2> vnet_pbxConnect: pbxConnectEx Succeeded
14:23:32.076 [7812.11120] <2> logconnections: BPRD CONNECT FROM 163.243.51.17.63784 TO 163.243.51.180.1556 fd = 540
14:23:32.135 [7812.11120] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
14:23:32.135 [7812.11120] <1> CGlobalInformation::VCSVirtualNameList: CONTINUATION: - The system cannot find the path specified.
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Native Client
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Native Client\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Native Client\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry entry not found for: SOFTWARE\Microsoft\Microsoft SQL Native Client\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server Native Client 10.0
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 10.0\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server Native Client 10.0 is installed on the system
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server Native Client 11.0
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 11.0\
14:23:32.135 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 11.0\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server Native Client 11.0 is installed on the system
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: ODBC Driver 11 for SQL Server
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\MSODBCSQL11\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\ODBC Driver 11 for SQL Server\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry entry not found for: SOFTWARE\Microsoft\MSODBCSQL11\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\DataAccess\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server\
14:23:32.136 [7812.11120] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server is installed on the system
14:23:32.137 [7812.11120] <4> getServerName: Read server name from nb_master_config: MasterServer
14:23:32.138 [7812.11120] <4> CDBIniParms::CDBIniParms: INF - NT User is Mike
14:23:32.165 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:23:32.185 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_1>, SQL userid <SQLacct> handle <0x00649960>.
14:23:32.258 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_1>, SQL userid <SQLacct> handle <0x0064abc0>.
14:23:32.264 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'SQLacct'.>.
14:23:32.266 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Failed to connect. Attempting operation with next installed ODBC Driver <SQL Server Native Client 11.0>
14:23:32.278 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_2>, SQL userid <SQLacct> handle <0x0064b610>.
14:23:32.328 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_2>, SQL userid <SQLacct> handle <0x0064c870>.
14:23:32.334 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'SQLacct'.>.
14:23:32.334 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Failed to connect. Attempting operation with next installed ODBC Driver <SQL Server>
14:23:32.345 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0064f2c0>.
14:23:32.396 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x005784a0>.
14:23:32.428 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:32.428 [7812.11120] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x005784a0>
14:23:32.649 [7812.11120] <4> CDBbackmain::LoadUserLogin: INF - Creating a read-only DSN for instance <MSSQLSERVER>
14:23:32.649 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Creating an APPLICATION_INTENT=ReadOnly DSN
14:23:32.649 [7812.11120] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 11.0>
14:23:32.654 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_4>, SQL userid <SQLacct> handle <0x00579a70>.
14:23:32.661 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_4>, SQL userid <SQLacct> handle <0x0057a210>.
14:23:32.663 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'SQLacct'.>.
14:23:32.664 [7812.11120] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0057a210>
14:23:32.664 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0057a640>.
14:23:32.679 [7812.11120] <4> DBConnect: INF - Failed sql connect try #1
14:23:33.710 [7812.11120] <4> DBConnect: INF - Failed sql connect try #2
14:23:34.742 [7812.11120] <4> DBConnect: INF - Failed sql connect try #3
14:23:35.773 [7812.11120] <4> DBConnect: INF - Failed sql connect try #4
14:23:36.805 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:36.805 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
14:23:36.805 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0057b7c0>.
14:23:36.827 [7812.11120] <4> DBConnect: INF - Failed sql connect try #1
14:23:37.860 [7812.11120] <4> DBConnect: INF - Failed sql connect try #2
14:23:38.891 [7812.11120] <4> DBConnect: INF - Failed sql connect try #3
14:23:39.922 [7812.11120] <4> DBConnect: INF - Failed sql connect try #4
14:23:40.953 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:40.953 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
14:23:40.953 [7812.11120] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_7812_11120_3>, SQL userid <SQLacct> handle <0x0057c140>.
14:23:40.983 [7812.11120] <4> DBConnect: INF - Failed sql connect try #1
14:23:42.015 [7812.11120] <4> DBConnect: INF - Failed sql connect try #2
14:23:43.046 [7812.11120] <4> DBConnect: INF - Failed sql connect try #3
14:23:44.078 [7812.11120] <4> DBConnect: INF - Failed sql connect try #4
14:23:45.109 [7812.11120] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQLacct'.>.
14:23:45.110 [7812.11120] <16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN <NBMSSQL_7812_11120_3> as user <SQLacct>
14:23:45.110 [7812.11120] <4> CDBbackmain::dbbackup: INF - Results of executing <tranlogs.bch>: <0> operations succeeded. <0> operations failed.
14:24:05.109 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.112 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.115 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.117 [7812.11120] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
14:24:05.120 [7812.11120] <4> CGlobalInformation::DSNCleanUp: INF - SQLDataSources did not fetch any ODBC user data source names
05-19-2016 12:22 PM
It does look like a permissions issue.
2 Netbackup Services are running as SQLacct that has SQL permissions.
15:13:58.475 [11104.12328] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_11104_12328_1>, SQL userid <SQLacct> handle <0x006eacd0>.
15:13:58.479 [11104.12328] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <297><[Microsoft][SQL Server Native Client 11.0][SQL Server]The user does not have permission to perform this action.>.
15:13:58.480 [11104.12328] <16> CDBbackcat::ExecuteSQLQuery: ERR - Internal error. See the dbclient log for more information.
15:13:58.480 [11104.12328] <32> CDBbackcat::ExecuteSQLQuery: ERR - Error found executing <SELECT isnull(cluster_name, '') FROM master.sys.dm_hadr_cluster>.
15:13:58.480 [11104.12328] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006eacd0>
15:13:58.480 [11104.12328] <16> CDBbackcat::GetClusterName: ERR - Internal error. See the dbclient log for more information.
15:13:58.481 [11104.12328] <32> CDBbackcat::GetClusterName: ERR - Error found executing <SELECT isnull(cluster_name, '') FROM master.sys.dm_hadr_cluster>.
15:13:58.481 [11104.12328] <4> CDBbackcat::GetDatabases: INF - WARNING: Failed to obtain cluster name.
15:13:58.481 [11104.12328] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_11104_12328_1>, SQL userid <SQLacct> handle <0x006eacd0>.
15:13:58.484 [11104.12328] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006eacd0>
15:13:58.484 [11104.12328] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_11104_12328_1>, SQL userid <SQLacct> handle <0x006eacd0>.
15:13:58.488 [11104.12328] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006eacd0>
15:13:58.488 [11104.12328] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <ServerProd> on server <ServerProd>.
15:13:58.488 [11104.12328] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_11104_12328_1>, SQL userid <SQLacct> handle <0x006eacd0>.
15:13:58.492 [11104.12328] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <297><[Microsoft][SQL Server Native Client 11.0][SQL Server]The user does not have permission to perform this action.>.
15:13:58.492 [11104.12328] <16> CDBbackcat::ExecuteSQLQuery: ERR - Internal error. See the dbclient log for more information.
15:13:58.492 [11104.12328] <32> CDBbackcat::ExecuteSQLQuery: ERR - Error found executing <SELECT db.name, CAST(db.recovery_model as INT), db.recovery_model_desc, CAST(db.state as INT), db.state_desc, CAST(db.is_in_standby AS INT), CAST(sysdb.status as INT), isnull(ag.name, ''), isnull(convert(nvarchar(50), ag.group_id), ''), isnull(ag_rep_states.role_desc, ''), isnull(ag_rep.secondary_role_allow_connections_desc, ''), isnull(ag_rep_states.operational_state_desc, '') FROM sys.databases as db LEFT JOIN sys.availability_databases_cluster as dbc ON db.group_database_id = dbc.group_database_id LEFT JOIN sys.availability_groups as ag ON dbc.group_id = ag.group_id LEFT JOIN sys.dm_hadr_availability_replica_states as ag_rep_states ON db.replica_id = ag_rep_states.replica_id LEFT JOIN sys.availability_replicas as ag_rep ON db.replica_id = ag_rep.replica_id JOIN sys.sysdatabases as sysdb on db.database_id = sysdb.dbid where db.name != 'tempdb' AND db.source_database_id is NULL ORDER BY db.name>.
15:13:58.492 [11104.12328] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006eacd0>
15:13:58.492 [11104.12328] <16> CDBbackcat::GetDatabases: ERR - Internal error. See the dbclient log for more information.
15:13:58.493 [11104.12328] <32> CDBbackcat::GetDatabases: ERR - Error found executing <SELECT db.name, CAST(db.recovery_model as INT), db.recovery_model_desc, CAST(db.state as INT), db.state_desc, CAST(db.is_in_standby AS INT), CAST(sysdb.status as INT), isnull(ag.name, ''), isnull(convert(nvarchar(50), ag.group_id), ''), isnull(ag_rep_states.role_desc, ''), isnull(ag_rep.secondary_role_allow_connections_desc, ''), isnull(ag_rep_states.operational_state_desc, '') FROM sys.databases as db LEFT JOIN sys.availability_databases_cluster as dbc ON db.group_database_id = dbc.group_database_id LEFT JOIN sys.availability_groups as ag ON dbc.group_id = ag.group_id LEFT JOIN sys.dm_hadr_availability_replica_states as ag_rep_states ON db.replica_id = ag_rep_states.replica_id LEFT JOIN sys.availability_replicas as ag_rep ON db.replica_id = ag_rep.replica_id JOIN sys.sysdatabases as sysdb on db.database_id = sysdb.dbid where db.name != 'tempdb' AND db.source_database_id is NULL ORDER BY db.name>.
15:13:58.493 [11104.12328] <4> CDBbackcat::GetDBNames: INF - Error: Failed to query database list for instance: MSSQLSERVER.
15:13:58.493 [11104.12328] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006e98b0>
05-19-2016 08:00 PM
Hi,
You may want to read below articles to configure MSSQL Backups and Restore.
https://www.veritas.com/support/en_US/article.TECH39418
https://www.veritas.com/support/en_US/article.000071169
FYI.. NBU Client Service can be running with "LocalSystem" Account.
05-20-2016 05:32 AM
Hello,
it is definitely permission issue, however : remember that SQL Intelligent policies don't allow "Application Backup" schedule types, so you cannot launch SQL backup from the client if you have intelligent policies only. You must have at least one script-based "legacy" MS-SQL-Server policy for this clent if you want achieve this.
Not sure what you mean with "incase the standard Intelligent policy is not run frequent enough". In intelligent policies, you can create Transaction Log Backup schedule type with the frequency up to units of minutes. So create this and let it work according to required frequency, or run it manually.
Also no need to have two policies. Add schedule for Trx Log backups to MSSQL_Intelligent_ServerA policy.
regards
Michal
05-23-2016 08:12 AM
I have a policy, an intelligent policy, that kicks transaction logs every 2 hours.
Occasionally the intelligent policy tran logs fail due to system resources and the transaction logs fill up; therefore, I have created a Manual MS-SQL policy with an "Application Backup" schedule. The application backup should kick off when a disk threshold has been reached. The posts above have helped me work further down the path to get this working, but I am still receiving errors.
ServerA is running Windows Server 2008 R2 and MS SQL Server 2012 Enterprise Edition
domain\sqlAcct has sysAdmin rights in SQL
domain\sqlAcct is in Administrators group on Operating System
Netbackup Client Service and Netbackup Legacy Network service are running as domain\sqlAcct
09:14:05.147 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_2>, SQL userid <domain\sqlAcct> handle <0x006098b0>.
09:14:05.169 [1656.6032] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <serverA> has been made using standard security with DSN <NBMSSQL_1656_6032_2>
09:14:05.169 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006098b0>
09:14:05.174 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x006098b0>.
09:14:05.194 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006098b0>
09:14:05.198 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x006098b0>.
09:14:05.219 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006098b0>
09:14:05.223 [1656.6032] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <serverA> on server <serverA>.
09:14:05.223 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x006098b0>.
09:14:05.244 [1656.6032] <4> CDBbackcat::GetDatabases: INF - Querying sys.databases to determine database list
09:14:05.244 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x0060acb0>.
09:14:05.247 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0060acb0>
09:14:05.248 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x0060acb0>.
09:14:05.251 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0060acb0>
09:14:05.251 [1656.6032] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <serverA> on server <serverA>.
09:14:05.251 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x0060acb0>.
09:14:05.255 [1656.6032] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <297><[Microsoft][SQL Server Native Client 11.0][SQL Server]The user does not have permission to perform this action.>.
09:14:05.256 [1656.6032] <16> CDBbackcat::ExecuteSQLQuery: ERR - Internal error. See the dbclient log for more information.
09:14:05.256 [1656.6032] <32> CDBbackcat::ExecuteSQLQuery: ERR - Error found executing <SELECT isnull(cluster_name, '') FROM master.sys.dm_hadr_cluster>.
09:14:05.256 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0060acb0>
09:14:05.256 [1656.6032] <16> CDBbackcat::GetClusterName: ERR - Internal error. See the dbclient log for more information.
09:14:05.256 [1656.6032] <32> CDBbackcat::GetClusterName: ERR - Error found executing <SELECT isnull(cluster_name, '') FROM master.sys.dm_hadr_cluster>.
09:14:05.256 [1656.6032] <4> CDBbackcat::GetDatabases: INF - WARNING: Failed to obtain cluster name.
09:14:05.256 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x0060acb0>.
09:14:05.260 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0060acb0>
09:14:05.260 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x0060acb0>.
09:14:05.263 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0060acb0>
09:14:05.264 [1656.6032] <4> CDBbackcat::GetVirtualServer: INF - Accessing database instance <serverA> on server <serverA>.
09:14:05.264 [1656.6032] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_1656_6032_1>, SQL userid <domain\sqlAcct> handle <0x0060acb0>.
09:14:05.267 [1656.6032] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <297><[Microsoft][SQL Server Native Client 11.0][SQL Server]The user does not have permission to perform this action.>.
09:14:05.268 [1656.6032] <16> CDBbackcat::ExecuteSQLQuery: ERR - Internal error. See the dbclient log for more information.
09:14:05.268 [1656.6032] <32> CDBbackcat::ExecuteSQLQuery: ERR - Error found executing <SELECT db.name, CAST(db.recovery_model as INT), db.recovery_model_desc, CAST(db.state as INT), db.state_desc, CAST(db.is_in_standby AS INT), CAST(sysdb.status as INT), isnull(ag.name, ''), isnull(convert(nvarchar(50), ag.group_id), ''), isnull(ag_rep_states.role_desc, ''), isnull(ag_rep.secondary_role_allow_connections_desc, ''), isnull(ag_rep_states.operational_state_desc, '') FROM sys.databases as db LEFT JOIN sys.availability_databases_cluster as dbc ON db.group_database_id = dbc.group_database_id LEFT JOIN sys.availability_groups as ag ON dbc.group_id = ag.group_id LEFT JOIN sys.dm_hadr_availability_replica_states as ag_rep_states ON db.replica_id = ag_rep_states.replica_id LEFT JOIN sys.availability_replicas as ag_rep ON db.replica_id = ag_rep.replica_id JOIN sys.sysdatabases as sysdb on db.database_id = sysdb.dbid where db.name != 'tempdb' AND db.source_database_id is NULL ORDER BY db.name>.
09:14:05.268 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x0060acb0>
09:14:05.268 [1656.6032] <16> CDBbackcat::GetDatabases: ERR - Internal error. See the dbclient log for more information.
09:14:05.268 [1656.6032] <32> CDBbackcat::GetDatabases: ERR - Error found executing <SELECT db.name, CAST(db.recovery_model as INT), db.recovery_model_desc, CAST(db.state as INT), db.state_desc, CAST(db.is_in_standby AS INT), CAST(sysdb.status as INT), isnull(ag.name, ''), isnull(convert(nvarchar(50), ag.group_id), ''), isnull(ag_rep_states.role_desc, ''), isnull(ag_rep.secondary_role_allow_connections_desc, ''), isnull(ag_rep_states.operational_state_desc, '') FROM sys.databases as db LEFT JOIN sys.availability_databases_cluster as dbc ON db.group_database_id = dbc.group_database_id LEFT JOIN sys.availability_groups as ag ON dbc.group_id = ag.group_id LEFT JOIN sys.dm_hadr_availability_replica_states as ag_rep_states ON db.replica_id = ag_rep_states.replica_id LEFT JOIN sys.availability_replicas as ag_rep ON db.replica_id = ag_rep.replica_id JOIN sys.sysdatabases as sysdb on db.database_id = sysdb.dbid where db.name != 'tempdb' AND db.source_database_id is NULL ORDER BY db.name>.
09:14:05.268 [1656.6032] <4> CDBbackcat::GetDBNames: INF - Error: Failed to query database list for instance: MSSQLSERVER.
09:14:05.268 [1656.6032] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x006098b0>
05-23-2016 08:14 AM
I have just manually kicked off from client and run successfully.
I opened a command prompt window as user 'domain\sqlAcct' and ran the bch.
Should this not work within an Administrator command prompt? I also attemped using the dbbackex -u <user> -p <password> and included USERID and PASSWORD in the script.
05-24-2016 12:00 AM
05-24-2016 12:23 AM
Hello,
two notes:
- when your SQL client is defined between Servers on the Master (Host Properties\Master Server\Servers\Additional Servers), you can perform also admin actions like "remote" Manual Backup with bpbackup -i -p -s, directly from the client (as well as all admin actions, so consider if it is suitable from security perspective for you)
- it is not a good design when you must be constantly afraid of filled disk. Consider larger disk for transaction logs, or change of backup policy (switch to Simple Recovery Model and engage frequent differential backups to maintain required RPO, if point-in-time recovery is not a must. )
Regards
Michal
06-01-2016 01:10 PM
You are correct as I will be increasing the transaction log disk size.
06-01-2016 01:16 PM
Main problem is
OBJECTTYPE TRXLOG
TRXOPTION TAILLOG
For backups, these cannot be in the same script.
I was able to create a powershell script that runs every minute. If one of the trans logs is approaching 90% full a script is generated and then called with bpbackex.
Thank you everyone for the guidance to get to the solution.