SV: TDP SQL sessions wants to write to same tape...
2004-02-13 05:40:20
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
|
|
|