• Hi Peery & Gila,

    I test it in my local server getting error while executing below query

    Query :-

    ALTER DATABASE Test MODIFY FILE(name=Test_data,

    FILENAME='D:\Test\Data\Test.mdf')

    Error :- MODIFY FILE failed. File 'Test_data' does not exist.

    But log file is moved successfully...

    Please let me know where i did mistake.

    Thanks & Regards

    Satish Saidapur