Hi Zoltan,

Do not sound strange to my ears this type of performance with TSM
TDP/MSSQL without flashcopy.
For large database sets in MSSQL it's strongly recommended  to use
FASTBACK module.

Hope this helps.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Friday, September 16, 2011 3:52 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing

FYI, FWIW,  after increasing IDLETIMEOUT and COMMTIMEOUT to 120000
(ridiculous - yes I know one value is in seconds and the other in
minutes) and 2-STRIPES, the SQL backup of this database finally finished
after running 74-Hours.

Zoltan Forray
TSM Software & Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html



From:   Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   09/05/2011 01:21 PM
Subject:        [ADSM-L] LARGE MS-SQL TDP backup keeps failing
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



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?


Zoltan Forray
TSM Software & Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html


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