ADSM-L

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

2011-09-05 14:30:07
Subject: Re: [ADSM-L] LARGE MS-SQL TDP backup keeps failing
From: Zoltan Forray <zforray AT VCU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 5 Sep 2011 14:15:58 -0400
Idle timeout is also 6000. For 4TB it could take days......how big can I go?

Remco Post <r.post AT PLCS DOT NL> wrote:

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