Forum Discussion

GDYR_MPD's avatar
GDYR_MPD
Level 4
10 years ago
Solved

MSSQL bpbackex not running successfully

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

  1. MSSQL_Transaction_Logs with Policy type MS-Windows
  2. MSSQL_Intelligent_ServerA with Policy type MS-SQL-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?

7.7
Backing Up
Backup and Recovery
Configuring
NetBackup
Windows Server (2003-2008)
  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    10 years ago

    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

     

     

  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    10 years ago

    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

  • GDYR_MPD's avatar
    GDYR_MPD
    10 years ago

    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.

14 Replies

  • Will_Restore's avatar
    Will_Restore
    Level 6
    10 years ago

    MSSQL_Transaction_Logs with Policy type MS-Windows

    should be Policy type MS-SQL-Server

  • GDYR_MPD's avatar
    GDYR_MPD
    Level 4
    10 years ago

    Updated to MS-SQL-Server.  Still getting the same prompt after manually running.

    dbbackex

    0 operations succeeded, 0 operations failed

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago
    Have you run a successful Full SQL backup before attempting transaction log backup? To troubleshoot SQL backup failures, create dbclient log folder on the client under ...\netbackup\logs before next backup attempt. Copy log file in dbclient folder to dbclient.txt and upload here as File attachment.
  • GDYR_MPD's avatar
    GDYR_MPD
    Level 4
    10 years ago

    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

  • GDYR_MPD's avatar
    GDYR_MPD
    Level 4
    10 years ago

    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
     

  • GDYR_MPD's avatar
    GDYR_MPD
    Level 4
    10 years ago

    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>

  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    Moderator
    10 years ago

    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

     

     

  • GDYR_MPD's avatar
    GDYR_MPD
    Level 4
    10 years ago

    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>

     

  • GDYR_MPD's avatar
    GDYR_MPD
    Level 4
    10 years ago

    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.