3

Rather than the detach/attach, take the database offline, change the location, move the file, and set back online. Example DDL: --take database offline ALTER DATABASE test SET OFFLINE; --modify the file location ALTER DATABASE test MODIFY FILE ( NAME = 'log', FILENAME = 'd:\test2.ldf' ); --manually move the file to the new location --finally, set database ...


Only top voted, non community-wiki answers of a minimum length are eligible