Specify SQL2005 LogFiles Path on Install

[johnmeola]

Any assistance is appreciated.

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.

Thanks in advance,
John

[Erland Sommarskog]

(jo*******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[John]

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:

(jo*******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[John]

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:

(jo*******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Erland Sommarskog]

John (jo*******@gmail.com) writes:

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.

Yeah, but the only file you would be interested in moving is the tempdb
log. There is little reason to put the log files for the other system
databases on a separate disk.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[John]

Good point.

Thanks again :)

Erland Sommarskog wrote:

John (jo*******@gmail.com) writes:

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.

Yeah, but the only file you would be interested in moving is the tempdb
log. There is little reason to put the log files for the other system
databases on a separate disk.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx