How To... Take and Restore an Emergency Vault Backup

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 blank Virtual machine or another blank physical machine (RESTORING MACHINE)

1. Install Vault Server on a new machine
2. After a successful installation, Start the ADMS Console
3. Delete the Vault Database (Right click on the Database, click Delete)
4. Tools>Detach Master Vault
5. In Windows Explorer, navigate to the SQL Data folder where the DB 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 OS)
6. Delete these files "KnowledgeVaultMaster.mdf, KnowledgeVaultMaster_log.ldf" 

On the Live Production Machine

1. At the command prompt, type "services.msc"
2. Locate the "SQL Server (AUTODESKVAULT)" Service, right click it and select stop
3. In Windows Explorer, navigate to the SQL Data folder where the DB 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 OS)
4. Copy these files to a network location, KnowledgeVaultMaster.mdf, KnowledgeVaultMaster_log.ldf
5. **PLUS** all Vault and Library Databases (mdf and ldf files)
6. Ignore, master.mdf, mastlog.ldf, model.mdf, modellog.ldf, MS_AgentSigningCertificate.cer, MSDBData.mdf, MSDBLog.ldf, tempdb.mdf, templog.ldf.
7. To the same Network location, copy the filestore.
8. Restart the "SQL Server (AUTODESKVAULT)"

On the RESTORING MACHINE

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