How to move Data files from drive to E drive in MS SQL Server 2008 R2


  • Hi Experts,,

    We have MS SQL Server 2008 R2 on the Dev and Prod Servers(not yet went to live, testing is going on). We have installed SQL Server in the C Drive along with Data files also. Now issue is, C drive got fulled and dont have space to create the New datbase. By mistake, we have installed in the default location in C drive.

    But Client need Data files in the E drive not in the Default location in C drive.

    So, Could you please suggest the best ways to move the Data files from C drive to E drive with out lost any data.

    (we have configured Hyperion with SQL Server Databases and also we have lot of data regarding applications.)

    Quick response would be appreciated.



    Saturday, July 20, 2013 4:10 AM


All replies