Skip to main content
Version: v23.0

Changing the Default Database Locations for an Instance

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.