Posted by John on 08/04/06 14:05

Good point.

Thanks again :)

Erland Sommarskog wrote:
> 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: SQL Server 7.0 equiv of IDENTITY_CURRENT
• Prev in forum: Re: Help with Database Solution
• Thread view: Re: Specify SQL2005 LogFiles Path on Install

[Reply to this message]