Steps to Configure a backup using NetBackup 7.1 in a MSCS

[faisalpar]

Hi,

Can anyone give me the steps to configure Netbackup Server and Client in a 2 node (FailOver ) Cluster.

The Database (SQL Server 2008 R2) is mirrored to DR Cluster.

Here is our setup:

Server (Node) 1:    MBCLTATXDB1

Server (Node) 2:    MBCLTATXDB2

Cluster Name :       ATEX-DBCLUSTER

.Thanks

[Marianne]

You need a minimum of 2 policies:

1 x MS-Windows policy to backup the local, non-shared drives on the physical nodenames

1 x MS-SQL policy to backup clustered instance, using the virtual hostname used for the instance as Client name.  Backup script(s) must be copied to both nodes or else saved on shared drive. Details in NBU for SQL Guide.

See this HOWTO doc: 

About configuring backup policies for a NetBackup clustered server
http://www.symantec.com/docs/HOWTO44654

[Marianne]

Mirrored shared storage is normal with most cluster configs. 

My previous post still applies.

[faisalpar]

But my DB is mirrored. So should i need to configure any further steps?

[faisalpar]

I configured MS-Windows and MS-SQL Policy in Netbackup Master Server

My Batch File is as Follows

OPERATION BACKUP

DATABASE $ALL

SQLHOST "ATEX-SQLSVR"

NBSERVER "172.16.1.92"

MAXTRANSFERSIZE 6

BLOCKSIZE 7

POLICY AtexDBCluster

BROWSECLIENT "ATEX-SQLSVR"

NUMBUFS 2

SQLCOMPRESSION TRUE

ENDOPER TRUE

The error i am getting is 

11/23/2012 12:01:51 PM - Info nbjm(pid=6528) starting backup job (jobid=607) for client atex-dbcluster, policy AtexDBCluster, schedule Full  

11/23/2012 12:01:51 PM - Info nbjm(pid=6528) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=607, request id:{C9CCDDF0-14CC-4F6F-BA07-1A0F709EBC9C})  

11/23/2012 12:01:51 PM - requesting resource Any

11/23/2012 12:01:51 PM - requesting resource mbcltatxbkp.mpp.com.NBU_CLIENT.MAXJOBS.atex-dbcluster

11/23/2012 12:01:51 PM - requesting resource mbcltatxbkp.mpp.com.NBU_POLICY.MAXJOBS.AtexDBCluster

11/23/2012 12:01:51 PM - granted resource mbcltatxbkp.mpp.com.NBU_CLIENT.MAXJOBS.atex-dbcluster

11/23/2012 12:01:51 PM - granted resource mbcltatxbkp.mpp.com.NBU_POLICY.MAXJOBS.AtexDBCluster

11/23/2012 12:01:51 PM - granted resource mbcltatxbkp-hcart2-robot-tld-0

11/23/2012 12:01:51 PM - estimated 0 Kbytes needed

11/23/2012 12:01:51 PM - Info nbjm(pid=6528) started backup job for client atex-dbcluster, policy AtexDBCluster, schedule Full on storage unit mbcltatxbkp-hcart2-robot-tld-0

11/23/2012 12:01:51 PM - started process bpbrm (9140)

11/23/2012 12:01:52 PM - Info bpbrm(pid=9140) atex-dbcluster is the host to backup data from     

11/23/2012 12:01:52 PM - Info bpbrm(pid=9140) reading file list from client        

11/23/2012 12:01:52 PM - connecting

11/23/2012 12:01:55 PM - Info bpbrm(pid=9140) starting bphdb on client         

11/23/2012 12:01:55 PM - Info bphdb(pid=7108) Backup started           

11/23/2012 12:01:55 PM - connected; connect time: 00:00:03

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) INF - BACKUP STARTED USING        

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)    

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) Jun 17 2011 00:54:03         

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) Copyright (c) Microsoft Corporation         

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch, Op# = 1      

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) INF - Using backup image MBCLTATXDB1.MSSQL7.ATEX-SQLSVR.db.GeneraDB.~.7.001of001.20121123120157..C       

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) INF - backup database "GeneraDB" to VIRTUAL_DEVICE='VNBU0-6804-7120-1353652318' with  compression, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

11/23/2012 12:01:58 PM - Info dbclient(pid=6804) INF - Number of stripes: 1, Number of buffers per stripe 2. 

11/23/2012 12:01:59 PM - Info dbclient(pid=6804) INF - Created VDI object for SQL Server instance <ATEX-SQLSVR>. Connection timeout is <300> seconds.

11/23/2012 12:02:11 PM - Info dbclient(pid=6804) ERR - Error in VxBSACreateObject: 3.       

11/23/2012 12:02:11 PM - Info dbclient(pid=6804)     CONTINUATION: - System detected error, operation aborted.  

11/23/2012 12:02:11 PM - Info dbclient(pid=6804) ERR - Error in GetCommand: 0x80770004.       

11/23/2012 12:02:11 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:16 PM - Info dbclient(pid=6804) ERR - Error in VDS->Close: 0x80770004.       

11/23/2012 12:02:16 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:16 PM - Info dbclient(pid=6804) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 19(19) seconds.

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) INF - BACKUP STARTED USING        

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)    

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) Jun 17 2011 00:54:03         

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) Copyright (c) Microsoft Corporation         

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch, Op# = 2      

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) INF - Using backup image MBCLTATXDB1.MSSQL7.ATEX-SQLSVR.db.GS_Licence.~.7.001of001.20121123120219..C       

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) INF - backup database "GS_Licence" to VIRTUAL_DEVICE='VNBU0-6804-1068-1353652340' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) INF - Number of stripes: 1, Number of buffers per stripe 2. 

11/23/2012 12:02:20 PM - Info dbclient(pid=6804) INF - Created VDI object for SQL Server instance <ATEX-SQLSVR>. Connection timeout is <300> seconds.

11/23/2012 12:02:26 PM - Info dbclient(pid=6804) ERR - Error in VxBSACreateObject: 3.       

11/23/2012 12:02:26 PM - Info dbclient(pid=6804)     CONTINUATION: - System detected error, operation aborted.  

11/23/2012 12:02:26 PM - Info dbclient(pid=6804) ERR - Error in GetCommand: 0x80770004.       

11/23/2012 12:02:26 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:31 PM - Info dbclient(pid=6804) ERR - Error in VDS->Close: 0x80770004.       

11/23/2012 12:02:31 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:31 PM - Info dbclient(pid=6804) INF - OPERATION #2 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 13(13) seconds.

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) INF - BACKUP STARTED USING        

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)    

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) Jun 17 2011 00:54:03         

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) Copyright (c) Microsoft Corporation         

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch, Op# = 3      

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) INF - Using backup image MBCLTATXDB1.MSSQL7.ATEX-SQLSVR.db.LayoutXpert.~.7.001of001.20121123120234..C       

11/23/2012 12:02:35 PM - Info dbclient(pid=6804) INF - backup database "LayoutXpert" to VIRTUAL_DEVICE='VNBU0-6804-6324-1353652355' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

11/23/2012 12:02:36 PM - Info dbclient(pid=6804) INF - Number of stripes: 1, Number of buffers per stripe 2. 

11/23/2012 12:02:36 PM - Info dbclient(pid=6804) INF - Created VDI object for SQL Server instance <ATEX-SQLSVR>. Connection timeout is <300> seconds.

11/23/2012 12:02:41 PM - Info dbclient(pid=6804) ERR - Error in VxBSACreateObject: 3.       

11/23/2012 12:02:41 PM - Info dbclient(pid=6804)     CONTINUATION: - System detected error, operation aborted.  

11/23/2012 12:02:41 PM - Info dbclient(pid=6804) ERR - Error in GetCommand: 0x80770004.       

11/23/2012 12:02:41 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:41 PM - Info dbclient(pid=6804) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][ODBC SQL Server Driver][SQL Server]Write on "VNBU0-6804-6324-1353652355" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.

11/23/2012 12:02:41 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3271><[Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-6804-6324-1353652355:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>

11/23/2012 12:02:41 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>

11/23/2012 12:02:41 PM - Info dbclient(pid=6804) ERR - Error found executing <backup database "LayoutXpert" to VIRTUAL_DEVICE='VNBU0-6804-6324-1353652355' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.

11/23/2012 12:02:45 PM - Info dbclient(pid=6804) ERR - Error in VDS->Close: 0x80770004.       

11/23/2012 12:02:45 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:45 PM - Info dbclient(pid=6804) INF - OPERATION #3 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 11(11) seconds.

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) INF - BACKUP STARTED USING        

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)    

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) Jun 17 2011 00:54:03         

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) Copyright (c) Microsoft Corporation         

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch, Op# = 4      

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) INF - Using backup image MBCLTATXDB1.MSSQL7.ATEX-SQLSVR.db.master.~.7.001of001.20121123120248..C       

11/23/2012 12:02:49 PM - Info dbclient(pid=6804) INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-6804-8536-1353652369' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

11/23/2012 12:02:50 PM - Info dbclient(pid=6804) INF - Number of stripes: 1, Number of buffers per stripe 2. 

11/23/2012 12:02:50 PM - Info dbclient(pid=6804) INF - Created VDI object for SQL Server instance <ATEX-SQLSVR>. Connection timeout is <300> seconds.

11/23/2012 12:02:55 PM - Info dbclient(pid=6804) ERR - Error in VxBSACreateObject: 3.       

11/23/2012 12:02:55 PM - Info dbclient(pid=6804)     CONTINUATION: - System detected error, operation aborted.  

11/23/2012 12:02:55 PM - Info dbclient(pid=6804) ERR - Error in GetCommand: 0x80770004.       

11/23/2012 12:02:55 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:55 PM - Info dbclient(pid=6804) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][ODBC SQL Server Driver][SQL Server]Write on "VNBU0-6804-8536-1353652369" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.

11/23/2012 12:02:55 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3271><[Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-6804-8536-1353652369:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>

11/23/2012 12:02:55 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>

11/23/2012 12:02:55 PM - Info dbclient(pid=6804) ERR - Error found executing <backup database "master" to VIRTUAL_DEVICE='VNBU0-6804-8536-1353652369' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.

11/23/2012 12:02:59 PM - Info dbclient(pid=6804) ERR - Error in VDS->Close: 0x80770004.       

11/23/2012 12:02:59 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:02:59 PM - Info dbclient(pid=6804) INF - OPERATION #4 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 11(11) seconds.

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) INF - BACKUP STARTED USING        

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)    

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) Jun 17 2011 00:54:03         

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) Copyright (c) Microsoft Corporation         

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch, Op# = 5      

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) INF - Using backup image MBCLTATXDB1.MSSQL7.ATEX-SQLSVR.db.model.~.7.001of001.20121123120302..C       

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) INF - backup database "model" to VIRTUAL_DEVICE='VNBU0-6804-7400-1353652383' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

11/23/2012 12:03:03 PM - Info dbclient(pid=6804) INF - Number of stripes: 1, Number of buffers per stripe 2. 

11/23/2012 12:03:04 PM - Info dbclient(pid=6804) INF - Created VDI object for SQL Server instance <ATEX-SQLSVR>. Connection timeout is <300> seconds.

11/23/2012 12:03:09 PM - Info dbclient(pid=6804) ERR - Error in VxBSACreateObject: 3.       

11/23/2012 12:03:09 PM - Info dbclient(pid=6804)     CONTINUATION: - System detected error, operation aborted.  

11/23/2012 12:03:09 PM - Info dbclient(pid=6804) ERR - Error in GetCommand: 0x80770004.       

11/23/2012 12:03:09 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:03:09 PM - Info dbclient(pid=6804) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][ODBC SQL Server Driver][SQL Server]Write on "VNBU0-6804-7400-1353652383" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.

11/23/2012 12:03:09 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3271><[Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-6804-7400-1353652383:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>

11/23/2012 12:03:09 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>

11/23/2012 12:03:09 PM - Info dbclient(pid=6804) ERR - Error found executing <backup database "model" to VIRTUAL_DEVICE='VNBU0-6804-7400-1353652383' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.

11/23/2012 12:03:13 PM - Info dbclient(pid=6804) ERR - Error in VDS->Close: 0x80770004.       

11/23/2012 12:03:13 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:03:13 PM - Info dbclient(pid=6804) INF - OPERATION #5 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 11(11) seconds.

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) INF - BACKUP STARTED USING        

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)    

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) Jun 17 2011 00:54:03         

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) Copyright (c) Microsoft Corporation         

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch, Op# = 6      

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) INF - Using backup image MBCLTATXDB1.MSSQL7.ATEX-SQLSVR.db.msdb.~.7.001of001.20121123120316..C       

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) INF - backup database "msdb" to VIRTUAL_DEVICE='VNBU0-6804-4976-1353652397' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) INF - Number of stripes: 1, Number of buffers per stripe 2. 

11/23/2012 12:03:17 PM - Info dbclient(pid=6804) INF - Created VDI object for SQL Server instance <ATEX-SQLSVR>. Connection timeout is <300> seconds.

11/23/2012 12:03:23 PM - Info dbclient(pid=6804) ERR - Error in VxBSACreateObject: 3.       

11/23/2012 12:03:23 PM - Info dbclient(pid=6804)     CONTINUATION: - System detected error, operation aborted.  

11/23/2012 12:03:23 PM - Info dbclient(pid=6804) ERR - Error in GetCommand: 0x80770004.       

11/23/2012 12:03:23 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:03:23 PM - Info dbclient(pid=6804) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][ODBC SQL Server Driver][SQL Server]Write on "VNBU0-6804-4976-1353652397" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)>.

11/23/2012 12:03:23 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3271><[Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file "VNBU0-6804-4976-1353652397:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).>

11/23/2012 12:03:23 PM - Info dbclient(pid=6804) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>

11/23/2012 12:03:23 PM - Info dbclient(pid=6804) ERR - Error found executing <backup database "msdb" to VIRTUAL_DEVICE='VNBU0-6804-4976-1353652397' with  compression,  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.

11/23/2012 12:03:27 PM - Info dbclient(pid=6804) ERR - Error in VDS->Close: 0x80770004.       

11/23/2012 12:03:27 PM - Info dbclient(pid=6804)     CONTINUATION: - An abort request is preventing anything except termination actions.

11/23/2012 12:03:27 PM - Info dbclient(pid=6804) INF - OPERATION #6 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 11(11) seconds.

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\atex-dbcluster-full-22-11-12.bch>:      

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) <0> operations succeeded. <6> operations failed.       

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) INF - The following object(s) were not backed up successfully.   

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) INF - GeneraDB          

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) INF - GS_Licence          

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) INF - LayoutXpert          

11/23/2012 12:03:29 PM - Info dbclient(pid=6804) INF - master          

11/23/2012 12:03:30 PM - Info dbclient(pid=6804) INF - model          

11/23/2012 12:03:30 PM - Info dbclient(pid=6804) INF - msdb          

11/23/2012 12:03:50 PM - Error bpbrm(pid=9140) from client atex-dbcluster: ERR - command failed: none of the requested files were backed up (2)

11/23/2012 12:03:50 PM - Error bpbrm(pid=9140) from client atex-dbcluster: ERR - bphdb exit status = 2: none of the requested files were backed up

11/23/2012 12:03:52 PM - end writing

none of the requested files were backed up(2)

[Marianne]

Any reason why master server is specified as IP address in the script?

NBSERVER "172.16.1.92"

Please change to actual master server hostname and ensure forward and reverse name lookup between master and virtual hostname as well as port connectivity in both directions.

When the backup starts, a connection from the active node is initiated to the master.

We need to trace this connection in the following logs:

dbclient on active node
(Create this folder under ...\netbackup\logs on both nodes)

bprd on master
(Create this folder under ...\netbackup\logs and restart NBU to enable this log)

Try the backup again and copy the logs after the failure. Please rename logs to reflect process name (e.g. dbclient.txt) and post as File attachments.
 

[faisalpar]

Hi

Changed the SCRIPT as Follows but still not working 

OPERATION BACKUP

DATABASE $ALL

SQLHOST "ATEX-SQLSVR"

NBSERVER "mbcltatxbkp"

MAXTRANSFERSIZE 6

BLOCKSIZE 7

POLICY AtexDBCluster

BROWSECLIENT "ATEX-SQLSVR"

NUMBUFS 2

SQLCOMPRESSION TRUE

ENDOPER TRUE

Created Log folders in master server and db clients 

Attaching the Client and Master Logs

[Marianne]

15:20:38.771 [4984.8464] <16> serverResponse: ERR - server exited with status 239: the specified client does not exist in the specified policy

What is the Client name in the SQL policy (AtexDBCluster)?

[faisalpar]

Yes Atex-DBCluster

[Marianne · Accepted solution]

Policy name seems to be AtexDBCluster
According to your script the Client name should be ATEX-SQLSVR, not Atex-DBCluster.

Please double-check your policy.