Hi
I'm trying to set up an SQL backup in a environment with more that one SQL cluster group (Microsoft cluster) but for now am just trying to test a backup of the single default SQL virtual server in a single cluster group. I have set up an SQL policy that includes the virtual server name and am using the below .bch file on each node to try a backup. If I don't use the SQLINSTANCE $ALL statement and specify the host name the backup works fine but if I use the below settings, I can't get it backed up as it seems that NetBackup cannot enumerate the correct host and instance names.
I'm running NetBackup 6.5.1A on Windows Server 2003. The client is Windows 2003 R2 Enterprise x64 Edition OS and SQL 2005 64-bit Enterprise Edition.
OPERATION BACKUP
SQLINSTANCE $ALL
DATABASE $ALL
NBSERVER "MDRBUPMED01.BUP.SDP.NET.NZ"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
If I turn on logging I get the following error in the dbclient log file on the client
15:05:10.650 [3960.2760] <4> VxBSAInit: Veritas NetBackup XBSA Interface - 6.5 0
OK stuff...
15:05:13.557 [3960.2760] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
15:05:13.557 [3960.2760] <1> CGlobalInformation::VCSVirtualNameList: CONTINUATION: - The system cannot find the path specified.
15:05:13.557 [3960.2760] <4> dbc_GetServerName: entering dbc_GetServerName.
15:05:13.557 [3960.2760] <4> getServerName: Read server name from nb_master_config: mdrbupmed01.bup.sdp.net.nz
15:05:13.557 [3960.2760] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
15:05:18.572 [3960.2760] <4> SQLEnumerator: INF - Enumerated SQL hosts: SERVER:Server={(local),MDRSRWSQL01N2,MDRSRWSQL01V1,MDRSRWSQL01V2\BSPPROD,MDRSRWSQL01V3\BSPSTAGING,MDRSRWSQL01V4\ESB,MDRSRWSQL03N1,MDRSRWSQL03V1};UID:Login ID=?;PWD:Password=?;Trusted_Connection:Use Integrated Security=?;*APP:AppName=?;*WSID:WorkStation ID=?;
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - Hosts and instances retrieved from host list string
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: MDRSRWSQL01N2
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: <default>
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: MDRSRWSQL01V1
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: <default>
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: MDRSRWSQL01V2
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: BSPPROD
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: MDRSRWSQL01V3
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: BSPSTAGING
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: MDRSRWSQL01V4
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: ESB
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: mdrsrwsql03n1
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: <default>
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - host: MDRSRWSQL03V1
15:05:18.572 [3960.2760] <4> CGlobalInformation::SQLEnumerator: INF - instance: <default>
15:05:18.572 [3960.2760] <16> CDBbackmain::UpdateBatchFileForAllInstances: USER - An instance of SQL Server was not found on this client.
15:05:18.572 [3960.2760] <4> CDBbackmain::dbbackup: INF - Results of executing <C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\all_full.bch>:
<0> operations succeeded. <0> operations failed.
15:05:38.572 [3960.2760] <4> CGlobalInformation::DSNCleanUp: INF - SQLDataSources did not fetch any ODBC user data source names
15:05:38.572 [3960.2760] <4> VxBSATerminate: INF - entering VxBSATerminate.
15:05:38.572 [3960.2760] <4> VxBSAGetEnv: INF - entering GetEnv - NBBSA_DEBUGFD
15:05:38.572 [3960.2760] <4> VxBSAGetEnv: INF - returning -
The actual node and virtual server are highlighted in blue.
Any ideas on what I'm doing wrong?
Thanks in advance