Best practice for database move to new disk RRS feed

  • Question

  • Good morning,

    Hopefully this is a straight forward question/answer, but we know how these things go...

    We want to move a SQL Server Database data file (user database, not system) from the D: drive to the E: drive.

    Is there a best practice method?

    My colleague has offered "ALTER DATABASE XXXX MODIFY FILE" whilst I'm more inclined to use "sp_detach_db".

    Is there a best practice method or is it much of a muchness?



    Wednesday, November 12, 2014 11:18 AM


All replies