Emergency Backup and Restore Routine

You may find yourself in the situation where, for an environmental reason, it is not possible to take a supported Backup from your ADMS Console. The following steps should only be carried out as a last resort when all other avenues have been explored.

On a clean machine (Restoring Machine)

• Install Vault Server on a new machine.
• After a successful installation, Start the ADMS Console.
• Delete the Vault Database (Right click on the Database > Delete).
• Tools > Detach Master Vault.
• In Windows Explorer, navigate to the SQL Data folder where the Database files are configured to reside. By Default this is going to be something like "C:\Program Files\Microsoft SQL Server\MSSQL10_50.AUTODESKVAULT\MSSQL\DATA" (This location will vary depending on your Operating System).
• Delete these files KnowledgeVaultMaster.mdf and KnowledgeVaultMaster_log.ldf.

On the Live Production Machine

• At the command prompt, type services.msc.
• Locate the SQL Server (AUTODESKVAULT) Service, right click > Stop.
• In Windows Explorer, navigate to the SQL Data folder where the Database files are configured to reside. By Default this is going to be something like "C:\Program Files\Microsoft SQL Server\MSSQL10_50.AUTODESKVAULT\MSSQL\DATA" (This location will vary depending on your Operating System).
• Copy these files to a network location, KnowledgeVaultMaster.mdf and KnowledgeVaultMaster_log.ldf.
• PLUS all Vault and Library Databases (*.mdf and *.ldf files).
• Ignore the following: master.mdf, mastlog.ldf, model.mdf, modellog.ldf, MS_AgentSigningCertificate.cer, MSDBData.mdf, MSDBLog.ldf, tempdb.mdf and templog.ldf.
• To the same Network location, copy the Filestore.
• Restart the SQL Server (AUTODESKVAULT) Service.

On the Restoring Machine

• Copy the production Databases to the default SQL Folder, "C:\Program Files\Microsoft SQL Server\MSSQL10_50.AUTODESKVAULT\MSSQL\DATA".
• Copy the Filestore to the intended location.
• In the ADMS Console, Attach the Master Vault (Tools > Attach Master Vault).
• Once attached you will need to delete the unattached Vault Databases under Vaults and Libraries.
• Attach the Vault and Library Databases.
• Run an SQL Maintenance Plan as descibed in the Advanced Configuration Guide. check for any errors!
• Once all Vault and Library Databases are attached and linked to the correct Filestore, take a ADMS Console backup

This is an extract from the Cracking the Vault, Manufacturing Community Blog.