Default data and log file paths in SQL Server
It's well understood that you shouldn't have your MDF and LDF files on the same spindles if you want to maximize IO performance. Unfortunately, you can only specify a default location for the SQL Server "data files", which includes both the MDF and the LDF. Is there a way to separate these so that the these files get created by default in different locations (ex. MDF files go to F:\Data\ and LDF files go to G:\Logs\)?
I can't seem to find any references here. The reason I bring this up is actually for SharePoint. When a new SharePoint site collection is created, the system optionally creates a new Content DB. I'd like to not require the DBA get involved to move the log files to the correct physical location after the new ContentDB has been created.
EDIT
I posted the question online for some assistance and our own local Geoff Hiten responded:
SQL Server 2005 Management Studio.
Object Explorer. Right-click on the server name and select properties.
Choose Database Settings under "select a page (left side)
Last two fields are data and log default locations.
SQL 2005
SQL 2000