[dba-SQLServer] Moving the log file

Yes, you need to click on the database name and choose Properties.  You can
change where the Database and Transaction Log files get stored from tabs on
this screen.

Doris Manning
mikedorism at verizon.net

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Thursday, September 28, 2006 10:43 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Moving the log file

Is there a way to have SQL Server itself move it's log file to another
drive?  I created a database and it creates the log file in the same
directory as the data file.  If I detach the database and physically move
the log file, SQL Server refuses to allow me to attach the database again
using (changing the location of) the log file on the other drive.  If I just
click OK with the little red X in the log file location, it creates a new
log file back in the same location as the data file. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com