ADSM-L

Re: [ADSM-L] SQL TDP in MSCLuster

2007-09-01 18:47:28
Subject: Re: [ADSM-L] SQL TDP in MSCLuster
From: Fred Johanson <Fred AT UCHICAGO DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sat, 1 Sep 2007 17:44:01 -0500
Thanks Richard,
 
Our DBAs do not like TDp and blame it for everything.  He claims to have 
researched it thoroly and left it for me to figure out.

________________________________

From: ADSM: Dist Stor Manager on behalf of Richard Sims
Sent: Sat 9/1/2007 2:48 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SQL TDP in MSCLuster



On Aug 31, 2007, at 9:18 PM, Fred Johanson wrote:

> ...The DBA is sure he has found the solution.  When he starts the
> backup, this is the generated command:
>
> BACKUP failed to complete the command USE master BACKUP DATABASE
> [ProdDB] TO VIRTUAL_DEVICE=N'TDPSQL-000017B8-0000' WITH
> BLOCKSIZE=512, MAXTRANSFERSIZE=1048576, NAME=N'full',
> DESCRIPTION=N'TDPSQL-000017B8-0000 (TDP MS SQL V2)'
>
> He's convinced the problem is with the MAXTRANSFERSIZE.  If I would
> change that, everything would work.  But it's not a TSM parameter.
> He says it doesn't appear in MSSQL either.  So where does this come
> from?  Is it really the culprit?  Support hasn't been very
> supportive so far, prefering to concentrate on the cluster.

Hi, Fred -

One wonders if the DBA did any research in his assigned area, in that
info on the MS SQL MaxTransferSize parameter is readily available, as
in http://support.microsoft.com/kb/873482 , where the value in play
looks nominal.

There have to be some messages somewhere saying why the backup
failed, as the basis for actual problem pursuit.

    Richard Sims

<Prev in Thread] Current Thread [Next in Thread>