ADSM-L

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

2011-09-05 20:44:26
Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing
From: "Prather, Wanda" <wPrather AT ICFI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 6 Sep 2011 00:41:07 +0000
Also double check that the SQL admin doesn't accidentally have a local SQL 
backup (i.e. maintenance plan) enabled to create flat-file backups at the same 
time.  That will slow things to a halt.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Remco Post
Sent: Monday, September 05, 2011 1:39 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing

Hi,

check your idletimeout. I've noticed that a timeout of several hours might be 
required.

On 5 sep. 2011, at 19:21, Zoltan Forray/AC/VCU 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?
> 
> 
> 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

--
Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622