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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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

Reply via email to