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.