Zoltan,

investigate more deeply this "ACIPENSER.VCU.EDU (TDP MSSQL Win32) terminated - 
preempted by another operation."
Seems another operation (MSSQL or TSM MSSQL related) is killing your session, 
if so, is not a timeout question.

Kindly,

Carlo.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Zoltan Forray/AC/VCU
Sent: martedì 6 settembre 2011 19:13
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing

I don't think there is a firewall.

Well, it got further (700GB) before being killed by the TSM server.

9/6/2011 12:05:04 PM ANR0524W Transaction failed for session 59224 for node 
ACIPENSER.VCU.EDU (TDP MSSQL Win32) - data transfer interrupted.
9/6/2011 12:05:05 PM ANR0487W Session 59224 for node ACIPENSER.VCU.EDU (TDP 
MSSQL Win32) terminated - preempted by another operation.

At this rate, I don't think it is possible to back it up, especially if it is 
making this 1-4TB transaction.

I again have to ask the question - can you tell the SQL TDP to break-up the 
backup into multiple transactions, like you can with the Oracle TDP?



From:   Thomas Denier <Thomas.Denier AT JEFFERSONHOSPITAL DOT ORG>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   09/06/2011 10:27 AM
Subject:        Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



-----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.


-----   
Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute nel 
messaggio e negli eventuali allegati sono riservate al/ai destinatario/i 
indicato/i. Nel caso di erroneo recapito, si chiede cortesemente a chi legge di 
dare immediata comunicazione al mittente e di cancellare il presente messaggio 
e gli eventuali allegati. Si invita ad astenersi dall'effettuare: inoltri, 
copie, distribuzioni e divulgazioni non autorizzate del presente messaggio e 
degli eventuali allegati.

----------   
According to Italian law (D.Lgs 196/2003) information contained in this message 
and any attachment contained therein is addressed exclusively to the intended 
recipient. If you have received this message in error would you please inform 
immediately the sender and delete the message and its attachments. You are also 
requested not to make copies, nor to forward the message and its attachments or 
disclose their content unless authorised.