[dba-SQLServer] Moving the log file

JWColby jwcolby at colbyconsulting.com
Thu Sep 28 09:42:49 CDT 2006


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




More information about the dba-SQLServer mailing list