Posted by Erland Sommarskog on 08/04/06 07:06

John (johnmeola@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, 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

• Next in forum: Re: Having Problem While Importing a Text File
• Prev in forum: Re: table owner
• Thread view: Re: Specify SQL2005 LogFiles Path on Install

[Reply to this message]