22 Dec 2011

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.

No comments:

Post a Comment

Post a Comment