Previous Post Next Post

Steps to Configure a backup using NetBackup 7.1 in a MSCS

Created: 22 Nov 2012 | Updated: 23 Nov 2012 | 9 comments

faisalpar

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

Discussion Filed Under:

Backup and Recovery, NetBackup, Agents, Best Practice, Configuring, Tip/How to

Comments RSS Feed

Comments 9 Comments • Jump to latest comment

Marianne van den Berg Trusted Advisor Partner Accredited Certified

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:22 Nov 2012 : Link

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

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:22 Nov 2012 : Link

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

Marianne van den Berg Trusted Advisor Partner Accredited Certified

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:22 Nov 2012 : Link

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

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:22 Nov 2012 : Link

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 van den Berg Trusted Advisor Partner Accredited Certified

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:23 Nov 2012 : Link

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

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:23 Nov 2012 : Link

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

Attachment	Size
logs.rar	55.3 KB

Marianne van den Berg Trusted Advisor Partner Accredited Certified

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:23 Nov 2012 : Link

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

faisalpar

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:23 Nov 2012 : Link

Yes Atex-DBCluster

Marianne van den Berg Trusted Advisor Partner Accredited Certified

Steps to Configure a backup using NetBackup 7.1 in a MSCS - Comment:23 Nov 2012 : Link

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

Steps to Configure a backup using NetBackup 7.1 in a MSCS

Comments 9 Comments • Jump to latest comment

Would you like to reply?

Links