ADSM-L

Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing

2011-09-06 10:41:30
Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing
From: Thomas Denier <Thomas.Denier AT JEFFERSONHOSPITAL DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 6 Sep 2011 10:26:40 -0400
-----Zoltan Forray wrote: -----

>I am trying to backup a LARGE SQL (4TB) database via the SQL TDP,
>without success.
>
>It will run for a while and then die - usually with the error:
>ANS1017E (RC-50): Session Rejected : TCP/IP communications failure.
>The last try backed up 125GB before failing.
>
>I have greatly increased the server communication timeout (6000
>seconds) guessing it is a timeout issue.
>
>I know very little about the SQL TDP (v5.5.5.0 - base TSM client is
>6.1.3.2 - yes I know it needs updating) and config options.  Is there
>a way to breakup the backup into chunks, like you can do with Oracle
>backups?
>
>Suggestions?

Does the backup pass through a firewall? Firewalls generally have a
timeout period for idle TCP sessions. This is rarely more than an
hour, and I have heard of firewalls with the timeout set as low as
15 minutes.