Post reply

MOVING DATA FILES

  • August 7, 2008 at 1:35 am

    #124638

    I planned to move my data file from one drive to another. What is the best way to accomplish this in SQL Server 2005?

    Thanks.

    Regards,

    Sahoong

  • August 7, 2008 at 1:42 am

    #854246

    Detach/attach worked for me when I had to do the same.

    Regards

    Gianluca

    -- Gianluca Sartori

  • August 7, 2008 at 2:09 am

    #854261

    Just to be on the safe side make sure u have a backup and also make sure u have run DBCC checkdb against the database. before taking the backup.. Seen cases where your not able to attach the file... in this case u can atleast restore from your backups ...

    Jay

    Jayanth Kurup[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply