How to configure the default file locations in SQL Server

Configure the default location of data and log files.

1. Access the properties of the SQL Server engine.
   1. Right-click the SQL Server engine. For example, for SQL Server 2008, right-click (local)(SQL Server 10.50.4000 - sa).
   2. Select the option Properties.
2. Configure the default location of the data and log files.
   1. Select the page Database Settings.
   2. Configure the default location of the files.
      • Data: Click ... to select the default folder where SQL Server stores the database data files.
      • Log: Click ... to select the default folder where SQL Server stores the database log files.

      

3. Restart SQL Server.