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:[email protected]] On Behalf Of Zoltan Forray/AC/VCU Sent: martedì 6 settembre 2011 19:13 To: [email protected] 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 <[email protected]> To: [email protected] Date: 09/06/2011 10:27 AM Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing Sent by: "ADSM: Dist Stor Manager" <[email protected]> -----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.
