Changing the Default Database Locations for an Instance
How to change the default database locations (Data, Log, Backup) for a virtualized instance with DxEnterprise.
Here is the recommended procedure:
Connect to the virtual instance through Microsoft SQL Server Management Studio (
Right-click on the instance under Object Explorer in the left-hand pane and select Properties.
Select Database Settings.
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.
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.