SQL Server: How to Change the Default Database Location

Description:

Instructions for changing the default Database locations.


Solution:

1. Open SQL Server Management Studio

2. Right Click on the SQL Server Instance node > Properties

3. Navigate to the "Database Settings" menu

4. Modify the "Database default locations"

5. Restart the following Windows Service:

SQL Server (MSSQLSERVER)

6. Create a new test database to verify that it is being created in the new, default location