Post reply

Moving mdf and ldf files to other disk, how SQL server 2005 will know?

  • July 23, 2008 at 8:53 am

    #210414

    I need to move a 250 GB file .MDF to another SAN disk. Once I move it (I will shutdown SQL Instance of course), how SQL Server 2005 will know to which disk drive has been moved? Any procedure to do it?. What is the best way?, or I can not do it?.

    Please help!!!!!

    Thanks

  • July 23, 2008 at 9:00 am

    #847109

    no need to shutdown sql instance,

    just set the database offline. Once this is done you can then move the disk file.

    After you copied the file to its new location use the alter database statement to modify the filepath then bring the database back online, job done 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 23, 2008 at 9:44 am

    #847158

    i have always detached the db, moved the files and then attach again. when you attach it will first not find the file and you have to point to it manually

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

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