None of the requested files were backed up

[Shrikumar]

Hello All,

I our envirounment we are having a netbackup issue (1: (2) none of the requested files were backed up ) when backuoing up sql using bch script.

Dbclient log has been given below

---------------------------------------------------------------------------------------------------------------------------

01:45:41.298 [47868.47268] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\AE_Full_Grp2.bch>:  <0> operations succeeded. <0> operations failed.
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.990: host_cache_size: 200 0x000000c8
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.991: cache_time: 3600 0x00000e10
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.1003: host_failed_cache_size: 40 0x00000028
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.1004: cache_time: 3600 0x00000e10
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.990: host_cache_size: 200 0x000000c8
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.991: cache_time: 3600 0x00000e10
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.1003: host_failed_cache_size: 40 0x00000028
01:46:01.438 [48324.46380] <2> init_cache: ..\libvlibs\vnet_hosts.c.1004: cache_time: 3600 0x00000e10
01:46:01.501 [48324.46380] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2043: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
01:46:01.501 [48324.46380] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2057: service: bprd
01:46:01.719 [48324.46380] <2> logconnections: BPRD CONNECT FROM 10.160.222.10.4331 TO 10.140.219.21.13724
01:46:01.954 [48324.46380] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
01:46:01.954 [48324.46380] <1> CGlobalInformation::VCSVirtualNameList:     CONTINUATION: - The system cannot find the path specified.
01:46:01.954 [48324.46380] <4> getServerName: Read server name from nb_master_config: memcf-master
01:46:01.954 [48324.46380] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
01:46:01.985 [48324.46380] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_48324_46380>, SQL userid <sa> handle <0x00be1348>.
01:46:44.016 [48324.46380] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_48324_46380>, SQL userid <sa> handle <0x00be2068>.
01:47:26.173 [48324.46380] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_48324_46380>, SQL userid <sa> handle <0x00be2ad0>.
01:47:26.267 [48324.46380] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_48324_46380>, SQL userid <sa> handle <0x00be33d0>.
01:47:26.329 [48324.46380] <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 'sa'.>.
01:47:26.329 [48324.46380] <16> CGlobalInformation::CreateDSN: ERR - Unable to login into SQL instance <ZBNAWLDB023\> as user <sa> using standard connection.
01:47:26.329 [48324.46380] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00be33d0>
01:47:26.329 [48324.46380] <16> CDBbackmain::LoadUserLogin: ERR - Internal error. See the dbclient log for more information.
01:47:26.329 [48324.46380] <32> CDBbackmain::LoadUserLogin: ERR - Error 64 has been returned from GetCurrentDSN

---------------------------------------------------------------------------------------------------------------------------

Also can anyone tell me from where do Netbackup MAster Ser get the user/passwd info abt sql server.

Thanks in Advance

Shrikumar

[RiaanBadenhorst]

Hi,

Which authentication method is used for your SQL database, Windows (Mixed) or SQL Intergrated?

[Kenneth_Hansen]

Did you make the backup script for your SQL policy on the client?

PS!! When executing the NBU SQL wizard on the client, you will set the credentills and select DB to backup. Your SQL Policy should the execute the script under backup selection.

[Marianne]

The Master server does not need access - the NetBackup Client Service on the SQL server needs access/logon.

Have a look at this doc: ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/276903.pdf

Extract:

3.1.1 Using standard SQL Server security.
Change the properties of the NetBackup Client service to set the “Log On As” to a Windows
account name. The Windows account name must be mapped to a SQL Server account with
backup privileges for the SQL Server. It is recommended to use the local administrator account.
• Log on to Windows using this account.
• Start the NetBackup for SQL Server GUI.
• Go to DBMS login parameters and enter the SQL user account and password that has
backup privileges for the database, usually the SQL account “sa”.

....

3.1.2 Using integrated SQL Server security.
Change the properties of the NetBackup Client service to set the “Log On As” account to a
Windows account that has backup privileges for the SQL Server. The account entered in the
NetBackup DBMS login parameters is not used. The batch file user id and password are also
ignored.

[emret]

Hi Shrikumar,

please check your nbu account has the sysdba and dbcreater role. If your account does not this permission please give permission your account.