Vault General Discussion

Vault General Discussion

18 Posts
0 Kudos
Registered: ‎08-11-2009
Post 1 of 5

Move SQL Database to new server

817 Views, 4 Replies
06-15-2010 07:02 AM



i've installed Vault Manufacturing 2010 with a remote SQL Server 2005. Now i want to move all Vault Databases to our new SQL 2008 (no R2!) server. The Advanced Configuration Guide only discribes how to do an In-Place upgrade.

Can someone help me?





Board Manager
613 Posts
235 Kudos
Registered: ‎02-01-2006
Post 2 of 5

Re: Move SQL Database to new server

06-15-2010 07:17 AM in reply to: ShaolinSam



The best way to do this is to perform the following steps:

  1. Perform a backup through the ADMS Console.
  2. Uninstall the Vault server.
  3. Install the Vault server again and point it to the new SQL server computer.
  4. Perform a restore from the backup done in step 1.


Irvin Hayes Jr
Product Manager
Autodesk, Inc.

New Member
1 Posts
0 Kudos
Registered: ‎12-29-2011
Post 3 of 5

Re: Move SQL Database to new server

12-29-2011 12:52 PM in reply to: ihayesjr

Can you please elaborate on "uninstall the vault server?" Do you mean detach? Delete? 


Also, what if we want to also upgrade from Vault 2010 to 2011 at the same time? Can 2011 import our 2010 backup? Would it be better to upgrade before moving the database or after?

Valued Mentor
622 Posts
95 Kudos
Registered: ‎01-14-2010
Post 4 of 5

Re: Move SQL Database to new server

11-03-2013 11:09 PM in reply to: ihayesjr
Shouldn't SQL be removed as 2a step?
Product Support
70 Posts
2 Kudos
Registered: ‎07-19-2010
Post 5 of 5

Re: Move SQL Database to new server

11-04-2013 04:50 AM in reply to: MaximUdod

Yes I agree that there should be a step 2a where you uninstall the SQL as well.



Kevin Jaufmann-Ludwig
Technical Support Specialist
Customer Service & Support
Autodesk, Inc.
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.