twitter youtube facebook linkedin email
Connect with:

Under the Hood - All things PDM and PLM

Migrating Your Autodesk Vault Server (Part 1 ADMS Backup and Restore)

Traci Peurasaari
November 13, 2017

While using Autodesk Vault, you may encounter the need to move your data from one server to another. Some of the reasons to move to another server could be due to hardware replacement, upgrades, or the wish to create a test environment with a copy of your production data. There are two supported methods to migrate your Autodesk Vault and its data to a new server:

Performing a Vault Backup and Restore and using the ADMS Detach and Attach command.  This article will focus on the first method, Backup and Restore, and a later article will focus on the second, the ADMS tool.

Is ADMS Backup and Restore the right direction for your organization?

Pros:  Backup and Restore creates all SQL permissions and migrates the databases.  It also maintains all Vault permissions.  This method backs up and validates all the Vaults, Content Centers, and the filestores.  Everything is contained in one folder and as a result, leaves only one folder to copy to the new server.

Cons: Time to complete can be long depending on the size of the database.  Furthermore, you have downtime from the production environment to backup, copy, and restore (except when creating a test server).  Additionally, you need space for both the backup file of the databases and filestores as well as the restores of each. 

Getting Started:

Before you begin you must have the following prerequisites installed: A matching or higher version of SQL Server as your original server and the same patch level version or higher of Autodesk Management Server (ADMS) Console installed.  These can be installed on a single server or multi-application environment and as a local or remote SQL Server configuration.  Instructions for installing SQL are available here (which includes instructions for a remote SQL Server configuration) and help to install Vault can be found here*IMPORTANT WARNING* After installing the ADMS Console do NOT open it on the new server/s, or you may not be able to proceed with the restore. Once you have finished installing Vault and SQL, you are ready to migrate your databases.

Steps:

  1.  From the ADMS Console on your current server – perform a backup – select Tools and select backup and restore
  2. Choose Backup and click on next
  3. Enter the backup location                                                                       
  4. Copy the Backup folder from the Current server to the new server
  5. From the ADMS Console on your new server – perform a restore – select Tools and backup and restore
  6. Choose Restore and select next
  7. Enter the backup folder you copied to above and where to restore the database data files to as well as filestore location (top level). Choosing original will default to the folder structure on the originating server that created the backup
  8. Once completed you can delete any Unassigned sites displayed with the original server name.

When Building a Test Server:

If you are migrating to a new server to build a test server you can use ADMS backup and restore at any time, there is no concern about downtime to production.  You need only install SQL and ADMS on the new server and restore the Backup.

Traci Peurasaari

I am a SQL/DBA specialist with Enterprise Priority Support. I have over 25 years of relational database experience in Microsoft SQL Server and Oracle. My experience spans both the administrative, development and support arenas. For the past 15 years I have done a significant amount of SQL support and training for customers. I have trained internal support staff in supporting and troubleshooting customer databases as well as customers in simple maintenance and support of their database systems. I am proficient in Database performance and tuning, backup and restore, replication and various areas of troubleshooting. My experience spans multiple industries from manufacturing to advertising to finance. Throughout my career – regardless of my title the Customer Service especially as it pertains to the Database has been my passion and I have always maintained my activities in it whether it be through customer support, development or Business Analytics and metrics.

0 Comments

'