Start a Conversation

Unsolved

This post is more than 5 years old

1328

May 10th, 2007 10:00

Cluster backup faied

I have configured backup for two node SQL cluster-SQL 2000
configured two virtual server clients one for backing up Quorum and Filesystem drives and another client for MSSQL:
I have used remote user account cluster.sql@xxx.com which is a domain account also local administrator in both nodes.

Below is the error in savegrp.log
Internal system error, please see nsr\applogs\xbsa.messages on the client system for reason.
XBSA -_nwbsa_is_retryable_error: received a network error (Severity 5 Number 13): client `bg3sqlclus1w.gdnindia.com' is not properly configured on the NetWorker Server
--------------------------------------------------------------------------
APPs
[4080] 05/10/07 11:30:05 nsrexecd.exe Version: 7.2.1.Build.311
[4080]
05/10/07 11:30:05 nsrsqlsv.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000,
5788] 05/10/07 17:54:58 Backing up BadgeImages...
[5788]
05/10/07 17:54:58 BACKUP database [BadgeImages] TO virtual_device='Legato#fbde5b4f-fd80-466e-8411-cbaedafe60a5' WITH name='LegatoNWMSQL'
[5788] 05/10/07 17:54:58 Internal system error, please see nsr\applogs\xbsa.messages on the client system for reason.
[5788] 05/10/07 17:54:58 Processing BadgeImages failed, the item will be skipped.

What could be the problem?

76 Posts

May 10th, 2007 10:00

It´s sounds like permissions problems, what is the listed nsr\applogs\xbsa.messages ?

14.3K Posts

May 10th, 2007 11:00

Is your client really called bg3sqlclus1w.gdnindia.com? When you do client initiated SQL backup does that work?

76 Posts

May 10th, 2007 13:00

Hum.., I need to change my glasses :-)
You need to configure the 2 physical clients of the cluster as a client of NetWorker Server.

128 Posts

May 10th, 2007 20:00

bg3sqlclus1w.gdnindia.com and bg3sqlclus2w.gdnindia.com are client resources for nodes

From backup server

* BMSDBCLUS:MSSQL:
* BMSDBCLUS:MSSQL: [1220] 05/11/07 08:54:28 Backing up Northwind...
* BMSDBCLUS:MSSQL: [1220]
05/11/07 08:54:28 BACKUP database [Northwind] TO virtual_device='Lega
to#30133368-b1d4-4a12-88d6-afe5c42d3110' WITH name='LegatoNWMSQL'
* BMSDBCLUS:MSSQL: [1220] 05/11/07 08:54:28 Internal system error, please see nsr\applogs\xbsa.
messages on the client system for reason.
* BMSDBCLUS:MSSQL: [1220] 05/11/07 08:54:28 Microsoft SQL Server Provider error:
* BMSDBCLUS:MSSQL: [1220] 05/11/07 08:54:28 Write on 'Legato#d6adbf08-e3a1-4f5f-8f4c-b34bec4049
fb' failed, status = 995. See the SQL Server error log for more details..
* BMSDBCLUS:MSSQL: [1220] 05/11/07 08:54:28 BACKUP DATABASE is terminating abnormally..
* BMSDBCLUS:MSSQL: [1220] 05/11/07 08:54:28 Processing Northwind failed, the item will be skipp
ed.

When backup initiated from client

[2788] 05/11/07 08:58:06 Backing up Northwind...
[2788]
05/11/07 08:58:06 BACKUP database [Northwind] TO virtual_device='Leg
ato#020daf3f-c7cf-4dcd-bdfe-01ab1988953d' WITH name='LegatoNWMSQL'
[2788] 05/11/07 08:58:06 Internal system error, please see nsr\applogs\xbsa
.messages on the client system for reason.
[2788] 05/11/07 08:58:06 Microsoft SQL Server Provider error:
[2788] 05/11/07 08:58:06 Write on 'Legato#2ba3ab1e-7d3a-42be-aadd-f0a86feec
f85' failed, status = 995. See the SQL Server error log for more details..
[2788] 05/11/07 08:58:06 BACKUP DATABASE is terminating abnormally..
[2788] 05/11/07 08:58:06 Processing Northwind failed, the item will be skip

I have put following in remote access
cluster.sql@bg3sqlclus1w.gdnindia.com
cluster.sql@bg3sqlclus1w.gdnindia.com
*@BMSDBCLUS.gdnindia.com
*@FANDSCLUSTER.gdnindia.com

128 Posts

May 10th, 2007 20:00

SQL server logs below error.
BackupMedium::ReportIoError: write failure on backup device 'Legato#020daf3f-c7cf-4dcd-bdfe-01ab1988953d'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Internal I/O request 0x3A549C80: Op: Write, pBuffer: 0x05590200, Size: 512, Position: 0, UMS: Internal: 0x3E7D5E56, InternalHigh: 0x20000000, Offset: 0x3FF18147, OffsetHigh: 0x20000000, m_buf: 0x00000043, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: Legato#020daf3f-c7cf-4dcd-bdfe-01ab1988953d

BACKUP failed to complete the command BACKUP database [Northwind] TO virtual_device='Legato#020daf3f-c7cf-4dcd-bdfe-01ab1988953d' WITH name='LegatoNWMSQL'

14.3K Posts

May 11th, 2007 02:00

bg3sqlclus1w.gdnindia.com and bg3sqlclus2w.gdnindia.com are client resources for nodes

Yes, but what nodes - physical or virtual ones? What has been said was to hint you needed physical hosts and virtual ones too. Are BMSDBCLUS.gdnindia.com and FANDSCLUSTER.gdnindia.com physical ones?

I also just realized you are using build 154 - before proceeding further to rule out some gothcas can apply latest build for SQL module v5? Is there anything in xbsa.messages? I would suggest to apply latest build, try again and then if it fails increase debug (do not use level 9 as that slows down whole thing, 3 or 5 should be more than enough), collect all data and logs and review it. If that doesn't give you any clue opet a case with support along with logs and configuration resources.

Btw, what arch is that SQL server on? ia64, x64 or EM64T? All 3 have different SQL module versions and you must make sure you use right one.

56 Posts

May 11th, 2007 04:00

client `bg3sqlclus1w.gdnindia.com' is not properly configured on the NetWorker Server

This usually means this full domain name is not on the alias list of backup client.

128 Posts

May 19th, 2007 02:00

FANDSCLUSTER and BMSDBCLUS are virtual hosts.

It finally worked after reinstalling (same build 154) and after adding all hostnames (physical and virtual) in servers file of physical nodes. Also added a *@* on remote field of all hosts I am unable to figure out where was the problem I had tried all these options before posting this thread.

Also I am unable to do MSSQL recovery it says BMSDBCLUS.gdnindia.com is not a client of bdc3bakup2w.

14.3K Posts

May 19th, 2007 08:00

Do you have BMSDBCLUS.gdnindia.com on alias list of BMSDBCLUS client resource?

128 Posts

May 19th, 2007 10:00

Yes

128 Posts

May 19th, 2007 10:00

Yes..it is in alias.
Also directed recovery of SQL DB is happening from servers other than cluster nodes.

14.3K Posts

May 19th, 2007 11:00

Could be something in a way how whole thing is set up - have support expect the configuration - must be something simple.
No Events found!

Top