• HanShi (7/1/2013)


    1. Take the database OFFLINE

    2. 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/