469,326 Members | 1,319 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Specify SQL2005 LogFiles Path on Install

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

Aug 3 '06 #1
5 1166
(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
Aug 3 '06 #2
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
Aug 3 '06 #3
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
Aug 3 '06 #4
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
Aug 4 '06 #5
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
Aug 4 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by jabernet | last post: by
reply views Thread by Knokmans | last post: by
2 posts views Thread by Ryan Langton | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.