Announcement

Collapse
No announcement yet.

How to change the path of SQL data to another drive.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to change the path of SQL data to another drive.

    For some reason if you want to change the SQL Data path then follow the below steps to move SQL data to another drive.

    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 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.

  • #2
    good lord I found this solution, was about to reinstall the SQL server to change the location. Glad I found this post.

    Thanks pete..
    Only I can live forever.

    Comment

    Working...
    X