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

2004-02-13 Thread goran
thank you - Original Message - From: "Del Hoobler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 13, 2004 1:00 PM Subject: Re: TDP SQL sessions wants to write to same tape... Niklas, Goran is correct. You need to make sure that MAXNUMMP fo

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

2004-02-13 Thread Del Hoobler
Niklas, Goran is correct. You need to make sure that MAXNUMMP for the NODENAME you are using for your SQL backups is set to at least to the number of stripes you are using. Also, turning on collocation by filespace will ensure that data for different stripes remains on different tapes so that th

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

2004-02-13 Thread Niklas Lundstrom
februari 2004 10:27 Till: [EMAIL PROTECTED] Ä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

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

2004-02-13 Thread goran
ebruary 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 b

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

2004-02-13 Thread Niklas Lundstrom
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 medi