Home Forums SQL Server 2005 SQL Server Newbies Moving a large index file from 1 drive to another RE: Moving a large index file from 1 drive to another

  • February 7, 2009 at 1:59 pm

    #940059

    dbv147 (2/6/2009)

    Hello,

    I need to move an index file to another drive and thought I'd get some advice on the best way to do this. The index is on an archive server so down time is not a problem. My plan was to shutdown the SQL services copy the file to the new location. Start up SQL then remove the original file from the file group then add the file to the same file group in the new location. Any suggestions or alternate methods are welcomed.

    Thanks

    U can use this .......

    alter database TESTdatabase set offline

    TestDatabase

    alter database TestDatabase

    Modify File ( Name = TestDatabase, FileNAme='E:\testdatabase_data.mdf')

    alter database TESTdatabase set online

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]