Changing the Default Database Locations for an Instance

Applies to…

  • DxEnterprise
  • Microsoft SQL Server

Summary

How to change the default database locations (Data, Log, Backup) for a virtualized instance with DxEnterprise.

Information

Here is the recommended procedure:

  1. Connect to the virtual instance through Microsoft SQL Server Management Studio (< VHost >\< Instance >).
  2. Right-click on the instance under Object Explorer in the left-hand pane and select “Properties”.
  3. Select “Database Settings”
  4. Under “Default database locations” set the desired locations for Data, Log and Backup.
    • You will need to ensure that this path is located on a volume within the disk group assigned to the VHost.
  5. Click “OK”
  6. Restart the instance using one of these methods:
    • Rehost the instance to another node (right-click on a node and select “Start hosting on node”).
    • Right-click on the instance and select “Stop managing an instance”, once complete, then right-click the instance and select “Start managing an instance”. This method keeps the instance on the same node.