How to change the Data folder for SQL Server from one drive to another

Sometimes you would need to change the DATA folder location of your MSSQL server, quite possible due to disk space limitation.

You just need to follow below steps  :

1. Open the SQL Server Management Studio on the Windows server.

2. Expand SQL Server Group >> MS SQL server <SQL Server_Name>.

   Right click on it and select properties.

3. Go to the Database Settings and then select Database default locations.

4. Before moving the Data folder, create the folder on the particular drive 

   where you want to move.

5. Browse the particular path of the MSSQL data folder on the new drive for Data

   and Log.
For Eg: You want to move the Data folder to the E drive. 

Just change the path to E:\MSSQL\DATA\

6. Click ok and you are done.