HanShi (7/1/2013)
1. Take the database OFFLINE2. copy the LOG file to the new location
3. Change the location in the master database with code:
ALTER DATABASE [dbname] MODIFY FILE (NAME = 'logical_name', FILENAME = 'drive_path_filename')
4. bring the database ONLINE (if this doesn't succeed then step 2 has failed)
5. remove the old (original) file (if this file is blocked, then step 3 has failed)
i tried these steps but got error at step 4
Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)".
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/