• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Vault

    Reply
    Contributor
    Posts: 18
    Registered: ‎08-11-2009

    Move SQL Database to new server

    662 Views, 2 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

    Please use plain text.
    Board Manager
    Posts: 416
    Registered: ‎02-01-2006

    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.

    Please use plain text.
    New Member
    SeanFromIT
    Posts: 1
    Registered: ‎12-29-2011

    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?

    Please use plain text.