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