Today, we are writing about how to change the default location for Data (.mdb) and Log file (.LDF) file in SQL Server, using SQL studio Management Studio. Below is screen shot from SQL 2016 instance.
- To view the database's default location, connect SQL Server, using SSMS.
- Once SQL Server will connect, right click on connected SQL Server and select Properties.
- On SQL Properties, select the database setting option from the left side of the opened wizard and verify the default location for SQL database.
- If you wish to change the same on the different drive, select Locate folder option and define the path, where you want to save the same.
- From here, you can change the path.
- It won't provide any effect for some time. We need to restart SQL Services from services.msc and find SQL Server. Restart the Application and check the same.
- We can restart SQL Server Services from SQL Manager as well.
Join the conversation! Your thoughts help the community grow.