[dba-SQLServer] Moving the log file

Stephen Hait shait at mindspring.com
Mon Oct 2 08:36:47 CDT 2006


> So I still don't know how to "move" a log file from one disk to another that
> was just detached (or not detached if necessary).

See if this helps:
EXEC sp_attach_db @dbname = N'yourdbname',
@filename1 = N'\\yourserver\c$\mssql7\data\your_data.mdf',
@filename2 = N'\\yourserver\c$\mssql7\data\your_log.ldf'



More information about the dba-SQLServer mailing list