Showing posts with label SSMS. Show all posts
Showing posts with label SSMS. Show all posts

Friday, November 8, 2019

Change Database default locations in SQL Server

Method 1: Change default database location via SQL Server Management Studio (SSMS):
Step 1. Right Click on Server and Select "Properties".



Step 2. in the "Server Properties" dialog box, navigate to "Database Settings" tab and data/log files location under "Database default locations" group.


 Step 3.  Click on "OK" to Save Changes.

Step 4.   As per Microsoft SQL Server Instance need to restart for to take effect. so Right Click on Server and Click on "Restart". It will prompt for confirmation - Press Yes. You can Restart Server Instance using Services.msc