Move a Vault or Database

When you install the Autodesk data management server, a single vault named Vault is created. The database files for the vault are created in the MSSQL$AUTODESKVAULT\Data folder under the Microsoft SQL Server installation folder.

Several of the databases located in the Data folder are used by Microsoft SQL Server while others are specific to the vault. Each database file (MDF) has an associated log file (LDF) that contains important transaction data and must be moved, backed up, and restored along with the database file.

KnowledgeVaultMaster.mdf is the master vault database and it maintains the list of users, user permissions, and a list of vaults and their corresponding filestore location.

Note: Important: Never modify information in the SQL database.

Vault.mdf is the database for the vault named Vault. Each vault also has a SQL Server log file associated with it called VaultName.ldf.

The second component of every vault is the associated file store where the files are stored. The file store is structured as a hierarchy of folders that are located under a main folder that has the same name as the vault. The filestore location for the default vault named Vault is C:\Documents and Settings\All Users\Application Data\Autodesk\VaultServer. Each data file is stored in its own folder in a normal, uncompressed format. The folders for the file store are created when you add the first file to the vault.

Note: Important: Never modify the files or folder structure in the file store. Only access these files through the client interface.

Follow the instructions in this section for moving a vault or a database.

Note: Refer to Managing File Stores for information on moving the file store.

Move a Vault

A Vault database can be moved by relocating the corresponding MDFand LDF files from their existing location to another location on the same computer.

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

MS SQL requires that the user under whom the SQL service is running must have Full Control for the location to where the database is being moved.

  1. Launch the Autodesk Data Management Server console.
  2. Select a vault from the Vaults folder.
  3. Select Actions ► Move Database.
  4. On the Move Database Files dialog, browse to the new location for Data file (MDF) and Log file (LDF).

    It is not necessary that both the MDF and LDF of a given vault be in the same location.

    Note: MS SQL requires that the location to where the database is being moved must be on the same computer where the database is currently located.
  5. Click OK on the browse dialog.
  6. Click OK on Move Database Files dialog.
  7. Click Yes on the prompt to proceed with the Move operation.

Move the Master Vault

The Knowledge Vault Master can be moved by relocating the corresponding MDF and LDF files from their existing location to another location on the same computer.

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

The user under which the SQL service is running must have Full Control to the location to which the database is being moved.

Move the Master Vault

  1. Launch the Autodesk Data Management Server console.
  2. Select Tools Move Master Vault.
  3. On the Move Database Files dialog browse to the new location for the Data file (MDF) and Log file (LDF).
    Note: The location to which the database is being moved must be on the same computer where the database is currently located.
  4. Click OK on the browse dialog.
  5. Click OK on the Move Database Files dialog.
  6. Click Yes on the prompt to proceed with the Move operation.

It is not necessary that both the Knowledge Vault Master MDF and LDF files be in the same location.

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.
  1. Select a vault from the Vaults folder.
  2. Select Actions ► Move Database
    Note: You can also right-click on the vault and select Move Database.
  3. 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.
  4. Click OK on the browse dialog.
  5. Click OK on the Move Database Files dialog.
  6. 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.

Move the Master Database

The Knowledge Vault Master 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 KVM 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.
  1. Select Tools Move Master Vault.
  2. On the Move Database Files dialog browse to the new location for the 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 Knowledge Vault Master database.
  3. Click OK on the browse dialog.
  4. Click OK on Move Database Files dialog.
  5. Select Yes on the prompt to proceed with the Move operation.
Note: It is not necessary that both MDF and LDF of the Knowledge Vault Master be at the same location.
Parent topic: Manage Vaults and Databases

Related Concepts

Related Information