Video Screencast Help

Steps to Configure a backup using NetBackup 7.1 in a MSCS

Created: 22 Nov 2012 • Updated: 23 Nov 2012 | 9 comments
This issue has been solved. See solution.

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

Comments 9 CommentsJump to latest comment

Marianne's picture

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

 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

faisalpar's picture

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

 

Marianne's picture

Mirrored shared storage is normal with most cluster configs. 

My previous post still applies.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

faisalpar's picture

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's picture

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.
 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

faisalpar's picture

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
AttachmentSize
logs.rar 55.3 KB
Marianne's picture

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)?

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Marianne's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION