Vault General Discussion

Vault General Discussion

Reply
Contributor
ShaolinSam
Posts: 18
Registered: ‎08-11-2009
Message 1 of 5 (808 Views)

Move SQL Database to new server

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

Hi,

 

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?

 

Yours

 

Sam

Board Manager
ihayesjr
Posts: 559
Registered: ‎02-01-2006
Message 2 of 5 (807 Views)

Re: Move SQL Database to new server

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

Sam,

 

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
SeanFromIT
Posts: 1
Registered: ‎12-29-2011
Message 3 of 5 (349 Views)

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
MaximUdod
Posts: 545
Registered: ‎01-14-2010
Message 4 of 5 (104 Views)

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
Kevin.Jaufmann-Ludwig
Posts: 69
Registered: ‎07-19-2010
Message 5 of 5 (95 Views)

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.
Announcements
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.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.