Changing the default root directory for database files

Use this procedure to change the root directory for database files for a SQL Server instance.

  1. Right-click your SQL Server instance node, and select Change default root directory for database files.
  2. Select a path to the logs, tables, and indexes, and click Next.
  3. On the Summary screen, verify the property values and click Finish.
  4. When the task is finished, a dialog is displayed. Click OK.
  5. To view the log file, either click View log or go to the Logs view.