Unsolved
This post is more than 5 years old
128 Posts
0
1328
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?
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?
axavier1
76 Posts
0
May 10th, 2007 10:00
ble1
14.3K Posts
0
May 10th, 2007 11:00
axavier1
76 Posts
0
May 10th, 2007 13:00
You need to configure the 2 physical clients of the cluster as a client of NetWorker Server.
saleesh1
128 Posts
0
May 10th, 2007 20:00
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
saleesh1
128 Posts
0
May 10th, 2007 20:00
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'
ble1
14.3K Posts
0
May 11th, 2007 02:00
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.
jsallila
56 Posts
1
May 11th, 2007 04:00
This usually means this full domain name is not on the alias list of backup client.
saleesh1
128 Posts
0
May 19th, 2007 02:00
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.
ble1
14.3K Posts
0
May 19th, 2007 08:00
saleesh1
128 Posts
0
May 19th, 2007 10:00
saleesh1
128 Posts
0
May 19th, 2007 10:00
Also directed recovery of SQL DB is happening from servers other than cluster nodes.
ble1
14.3K Posts
1
May 19th, 2007 11:00