Unsolved
This post is more than 5 years old
19 Posts
0
2466
March 23rd, 2009 18:00
Backup large SQL DB fail from group start but success from NWSQL module
Hi dears,
My situation as below. I have a NW server 7.4 sp3 on Redhat 4U6, and there is a Windows 2003 R2 sp2 MSCS runnig MS SQL 2005 SP2. I had configed it on NW server well. But every time I start it from NW group, it always failed on the backup capacity 100GB~120GB(the total backup capacity is 140GB). But when I launch the backup job from the SQL virtual client, it can backup success but no CFI index saved in NW server. Does anyone meet the situation of SQL backup fail? Thanks!
My situation as below. I have a NW server 7.4 sp3 on Redhat 4U6, and there is a Windows 2003 R2 sp2 MSCS runnig MS SQL 2005 SP2. I had configed it on NW server well. But every time I start it from NW group, it always failed on the backup capacity 100GB~120GB(the total backup capacity is 140GB). But when I launch the backup job from the SQL virtual client, it can backup success but no CFI index saved in NW server. Does anyone meet the situation of SQL backup fail? Thanks!



ble1
4 Operator
•
14.3K Posts
0
March 24th, 2009 06:00
Manual (client initiated) backups are updating index db, but they do not trigger index db save for that client after data has been saved - this is default behaviour.
kbuis
11 Posts
0
March 24th, 2009 07:00
When you configured your backup client on the NetWorker server what was the string you used in the backup command? Also did you fill in the correct username and password? What error is the group giving?
Also have you confirmed that file system backups of the clustered client work?
ble1
4 Operator
•
14.3K Posts
0
March 24th, 2009 08:00
jgwang
19 Posts
0
March 24th, 2009 09:00
The backup command I use as " nsrsqlsv -a virtual_name" and if I don't have the correct username and password, how can it backup around 120GB? The error message I can get from group start is "about due to inactivity timeout'. And I can backup the clustered file system well.
jgwang
19 Posts
0
March 24th, 2009 09:00
I also cannot believe that I cannot backup it well. I had config lots of the system after all.
I can monitor a situation. When the backup start, the data is through the real server's NIC to send backup data to backup server(use Linux iptraf command monitored), but near the break point, the NW server and client has another tcp hand shaking via the real server's ip and the virtual server's ip and both of them are all reset. Then the backup throughput stop. After a while(3 minutes, I set the inactivity timeout to 3), the group giving "abort inactivity timeout" message.
jgwang
19 Posts
0
March 24th, 2009 09:00
I mean the total backup capacity is, I can backup it from client using NMSQL GUI successful and alfter that I check the media of the saveset capacity. There is no any firewall between NW server and client. And I must correct my previous post, I can see the CFI index after manual bakup successful. Backup start from Group just failed and the only one reason is "abort due to inactivity timeout". But the most strange thing is, before the inactivity timeout, the backup speed still stand on 40~70MB/sec.
kbuis
11 Posts
0
March 24th, 2009 09:00
Kevin
Message was edited by:
Kevin Buis
ble1
4 Operator
•
14.3K Posts
0
March 24th, 2009 11:00
Also, make another test from server. When it breaks, check if nsrsqlsv is still active and perhaps just to make sure that both client and server can communicate with each other via RPC (you can use rpcinfo like rpcinfo -t 390113 1
jgwang
19 Posts
0
March 24th, 2009 16:00
The most strange thing is, there is no message in xbsa.message and the nsrsqlsv.raw without any error in it. And I had tried the "rpcinfo -p remote_host" command from NW server and client and there are 7939 tcp port active on NW client. Maybe I should try your suggestion, let you know after the test complete.
ble1
4 Operator
•
14.3K Posts
0
March 25th, 2009 01:00
jgwang
19 Posts
0
March 25th, 2009 02:00
I had try rpcinfo -t ,remote host> 390113 1, I get answer from virtual client is 1 waiting for virtual server name but not waiting for the virtual server with FQDN name.
ble1
4 Operator
•
14.3K Posts
0
March 25th, 2009 02:00
ble1
4 Operator
•
14.3K Posts
0
March 25th, 2009 03:00
jgwang
19 Posts
0
March 25th, 2009 03:00
Yes, it is really work, but work not properly!