Posted by John on 08/03/06 23:58

Understood and thanks for the quick reply.

But, what if I want the data files on one volume and the logs on
another?

I know I can do this afterwards by detaching, moving and reattaching.

But I would like to do it during the install.



Erland Sommarskog wrote:
> (johnmeola@gmail.com) writes:
> > I would like to know if there is a way to specify the path for database
> > log files to be located during the SQL2005 Standard installation.
> > Under the Advanced button there is the ability to specify a different
> > path for data files but nothing for logs.
>
> That setting includes the log files, as far as I know.
>
> Once you have installed you can set the default location for database
> files and log files separately from Management Studio.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]