ADSM-L

SV: TDP SQL sessions wants to write to same tape...

2004-02-13 05:40:20
Subject: SV: TDP SQL sessions wants to write to same tape...
From: Niklas Lundstrom <niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 13 Feb 2004 11:39:35 +0100
Hello

No problems with moutpoints ,and the pool is collocated. Perhaps I should 
change it to collocate by filespace instead. Thats sounds like a solution 
actually


/Niklas

-----Ursprungligt meddelande-----
Från: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] För goran
Skickat: den 13 februari 2004 10:27
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: Re: TDP SQL sessions wants to write to same tape...


if its same node with collocation turned on it might be max mount points value 
that should be increased (im not sure if this is aplicable for SQL
TDP)

goran.


----- Original Message -----
From: "Niklas Lundstrom" <niklas.lundstrom AT FORENINGSSPARBANKEN DOT SE>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Friday, February 13, 2004 10:04 AM
Subject: TDP SQL sessions wants to write to same tape...


Hello

I've been running a backup of a SQL server db but I took too long so I 
increased the stripe-parameter to 2 so it would utilize 2 sessions and 2 tape 
drives for the backup. However when the backup starts both sessions wants to 
write to the same volume, leaving one of the session in a media-wait state for 
the whole backup and the backup fails after 12h.

12,064 BPX-T- RecvW    0 S   20.5 K  62.6 G Node  TDP MSS- ROBUR22_SQL
        cp/Ip                                      QL
12,066 BPX-T- MediaW 13.0 H   5.2 K   2.5 M Node  TDP MSS- ROBUR22_SQL
        cp/Ip                                      QL

What can I do to fix this???


Regards
Niklas Lundstrvm
Swedbank

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