Francisco Tapia
fhtapia at gmail.com
Wed Jun 10 15:18:21 CDT 2009
> > When you are doing the install you can specify the default location of > these files (i'll google for how to change this), also for existing > databases just detach and re-attach with the log file on it's specific > location, for new databases you can specify the new location for log files, > none of the existing databases will automatically move the log files to a > new location, this must be done manually. > > > -Francisco > http://sqlthis.blogspot.com | Tsql and More... > > > On Wed, Jun 10, 2009 at 8:54 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > >> Is there a generic setting to tell SQL Server to place log files on a >> specific drive? Is it by the >> database? How is this done? I am going to set up a RAID 1 pair of 512 >> gig drives just to put the >> log files on, but I do not know how to specify that logs should go there. >> >> My business has me setting up a new database for each order. In fact what >> I actually do is copy an >> existing "template" database, renaming it to the order name. The log >> files can get pretty large >> (tens of gigs) depending on the order and processing involved. it would >> be nice not to have to >> remember to tell SQL Server to place the logs in a specific place each >> time I create a database. >> >> John W. Colby >> www.ColbyConsulting.com >> >> <snip>