Monday, 7 November 2016

How to View or Change the Default Locations for Database and Log Files Using SQL studio latest version.

Today we are writing about how to change Default location for Data (.mdb) and Log file (.LDF) file in SQL server using SQL studio Management Studio. Below is screen shots is from SQL 2016 instance.
  • To view Database default location Connect SQL server using SSMS.
  • Once SQL server will get connect, Right click on Connected SQL server and select Properties.
  • On the SQL Properties, Select Database setting option from Left side of opened wizard and verified the default location for SQL database.
  • If you wish to change the same on different drive, select Locate folder the option and define the path where you want to save the same.

  • From here you can change path.
  • It wont take any effect some time, we need to restart SQL services from services.msc and find SQL server and restart the application then check the same.
  • We can restart the SQL server services from SQL Manager as well.

No comments:

Post a Comment