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'