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 8, 2009 at 11:57 am

    #940175

    ALZDBA (2/8/2009)

    Indeed,Ahmad Osama, that is the best way (especially because downtime is not an issue) !

    (I was just reflecting on that this morning, you know how that goes 😉 )

    Or use the :

    -sp_detach_db

    - move the you intended to the new drive.

    - sp_attach_db specifying all file locations

    I would have suggested this approach...however he wants to move a single file to another location not the complete database....

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