Move a Database

A Vault database is moved by relocating the corresponding mdf, LDF files from their existing location to another location on the same computer.

The default path for the database files for a Vault is C:\Program Files\Microsoft SQL Server\MSSQL10_50.AUTODESKVAULT\MSSQL\DATA.

Note: The User under which SQL service is running must have Full Control for the location to which the database is being moved.

Select a vault from the Vaults folder.
Select Actions ► Move Database

Note: You can also right-click on the vault and select Move Database.
On the Move Database Files dialog browse to the new location for Data file (mdf) and Log file (LDF).

Note: Note: MS SQL requires that the new location be on the same computer as the current location for the database.
Click OK on the browse dialog.
Click OK on the Move Database Files dialog.
Select Yes on the prompt to proceed with the Move operation.

Note: It is not necessary that both mdf and LDF of a given vault be at the same location.