Jonathan,
after executing the alter database modify file command and putting back the database to offline.
and moving the physical files over to the new path. and when i try to set the database back to online, i get this error.
File activation failure. The physical file name "D:\MSSQLTEST\iww_statistics_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 1
Database 'iww_statistics' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.