Attach and Detach Vaults and Databases

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.

Attach and Detach Vaults

Follow the instructions in this section to attach and detach vaults.

Detach a Vault

Detaching a vault disconnects it from the server so it can be moved to another location. Before detaching the master vault database, you must detach all other databases. The vault and its log file are detached. The names of the files for a vault named "Vault" are:

  • Vault.mdf
  • Vault_log.ldf

 

These files must exist as a pair and cannot be renamed. The default location for these files is:

  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

 

Detaching a vault removes all permissions to the vault. Once the vault is re-attached, permissions for each user and group must be reassigned. In a multi-site environment, the file store path is deleted for all other sites. If the vault is re-attached, the file store path must be reassigned at each site.

  1. In the navigation pane, open the Vaults folder and then select a vault to detach.
  2. Select Actions  Detach.
  3. You are prompted to confirm your actions. Click OK.

 

The vault and its log file are detached.

After the vault is detached, you can move the two corresponding files. The .mdf and .ldf files must be kept together. Attaching a vault reconnects the set of vault files that have been moved to the database engine.

Attach a Vault

Attaching reconnects a vault that was from a different server or from the same server but moved to another physical location on the disk. When attaching a vault in a multi-site environment, the vault is disabled for all other sites by default. All other sites must enable the attached vault.

Note: When the master vault is attached, you must add the users to the vault so they can access it.

Basic Vault Attachment

If the vault data file (.mdf) and the associated log file are both located in the SQL data folder, use these steps to attach the vault:

  1. Launch the Autodesk Data Management Server Console.
  2. In the navigation pane, select the Vaults folder.
  3. Select Actions  Attach.
  4. In the Attach Vault dialog, select the Basic tab.
  5. Specify the data file to attach from the list of Available Data Files. The Available Data Files list is compiled from the .mdf files in the SQL data folder. If the desired data file is not listed, go to the Advanced tab and specifiy the directory.
  6. Enter the name of the file store or click the browse button to browse to the location of the file store.
  7. Enter the name of the vault.
  8. Click OK.

Advanced Vault Attachment

If the vault data file and the log file are not in the SQL data folder, use these steps to attach the vault:

  1. Launch the Autodesk Data Management Server Console.
  2. In the navigation pane, select the Vaults folder.
  3. Select Actions  Attach.
  4. In the Attach Vault dialog, select the Advanced tab.
  5. Enter the name of the data file to attach in the Data File field or click the browse button to browse the server for the data file (.mdf).
  6. Enter the name of the transaction log file associated with the data file in the Log File field or click the browse button to browse the server for the transaction log file (.ldf).
  7. Enter the name of the file store in the File Store field or click the browse button to browse to the location of the file store.
  8. Enter the name of the vault in the Vault Name field.
  9. Click OK.

Attach and Detach the Master Vault

The names of the files for the master vault are:

KnowledgeVaultMaster is the master database for the Autodesk data management server. Similar to the SQL master database, KnowledgeVaultMaster is a separate database containing common global administrative and configuration information for all of the vault and library databases on the Autodesk data management server.

Detach the Master Vault

Detaching KnowledgeVaultMaster disconnects it from the server so it can be moved to another location on the disk or to another server altogether. You must detach all other databases before detaching the KnowledgeVaultMaster vault.

  1. Launch the Autodesk Data Management Server Console.
  2. Verify that all users are logged out of the vault server before detaching a vault.
  3. Click Tools  Detach Master Vault.
  4. Click Yes to confirm your actions.

The vault and its log file are detached.

After the vault is detached, you can move the two corresponding files to any drive or partition on the same computer. The names of the files for the master vault are:

  • KnowledgeVaultMaster.mdf
  • KnowledgeVaultMaster_log.LDF
Note: These files must exist as a pair and cannot be renamed. The default location for these files is in the Data directory in the Microsoft SQL Server installation folder.

Attach the Master Vault

  1. Launch the Autodesk Data Management Server Console.
  2. Click Tools  Attach Master Vault.
  3. Specify the location for the master vault SQL data file, KnowledgeVaultMaster.mdf.
  4. Specify the location for the master vault transaction log file, KnowledgeVaultMaster.ldf.
  5. Re-attach any vaults that were previously detached from the master vault or create vaults.
Note: User access permissions are maintained when the master vault database is re-attached.

Detach the Master Database

KnowledgeVaultMaster is the master database for the Autodesk data management server. Similar to SQL's master database, KnowledgeVaultMaster is a separate database containing common global administrative and configuration information for all of the vault and library databases on the Autodesk data management server

Detaching KnowledgeVaultMaster disconnects it from the server so it can be moved to another location on the disk or to another server altogether.

You must detach all other databases before detaching the KnowledgeVaultMaster vault.

  1. Verify that all users are logged out of the vault server before detaching a vault.
  2. Click Tools  Detach Master Vault.
  3. Click Yes to confirm your actions.

The vault and its log file are detached.

After the vault is detached, you can move the two corresponding files to any drive or partition on the same computer. The names of the files for the master vault are:

Note: These files must exist as a pair and cannot be renamed. The default location for these files is in the Data directory in the Microsoft SQL Server installation folder.
Parent topic: Manage Vaults and Databases

Related Concepts

Related Information