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 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
No comments:
Post a Comment