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