Support Portal

Welcome, Guest Login

Support Center

Changing the Default Database Locations for an Instance

Last Updated: Jul 17, 2017 03:45PM PDT

Applies to...

  • DxEnterprise 15.0
  • DxEnterprise 15.5
  • DxEnterprise 16.0
  • DxEnterprise 17.0
  • 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.

Contact Us

support.desk@dh2i.com
http://assets1.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete