That is the way you want it setup. Even better is if you have a disk set just for tempdb. That would be if you have a high transaction server.

Dave

-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] Monday, June 10, 2002 11:30 AM
To: SQLDBA (E-mail)
Subject: tempdb log and data files


Hi everyone,

Do you know if it is bad to have the tempdb log on one disk array and tempdb
data on another?

Thanks
Meg


**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily of Mondial Assistance (UK) Ltd. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.

If you have received this email in error please notify the IT support desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please then delete this email and destroy any copies of it. Thank you.

Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ

Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered office as above
**********************************************************************


This message has been checked for all known viruses by the
MessageLabs Virus Scanning Service. For further information visit
http://www.messagelabs.com/
MS Sql Server LazyDBA home page