Separating MDF and LDF Files

[NWChowd]

I am going to be setting up a SQL Server 2000 database in the near future. I was wondering if it is optimal/advised that the data files and the log files should be stored on separate logical drives? or even physical drives? or, what is the best practice on this?



======================================
"I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."
-David Ricardo, classical economist
======================================

 

[JayKusch]

Best practice is to have them split on seperate physical drives if available. Also, if possible, the TempDB should be place on a seperate disc also.

Thanks

J. Kusch

 

[NWChowd]

Thanks, JayKusch. can you point me to any web resources for SQL Server Admin/config best practices, in general?

thanks again.
DMill

======================================
"I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."
-David Ricardo, classical economist
======================================

 

[JayKusch]

For a link ... try this one.

http://www.sql-server-performance.com/jk_sql_server_upgrade.asp

Also, download MSs new SQL Server Best Practices Analyzer. It will determine, based on MS guidelines, if your server is set optimally.

http://www.microsoft.com/downloads/...1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

Thanks

J. Kusch