Vault General Discussion

Reply
Distinguished Contributor
hans.martin.haga
Posts: 171
Registered: ‎09-23-2008
Message 1 of 5 (427 Views)

Vault installs 32 bit SQL Express

427 Views, 4 Replies
09-04-2012 12:44 AM

Why is only the 32 bit version of SQL Express 2008 bundled with the Vault server installation?

If you let the Vault installation wizard install SQL-server, it installs a 32 bit SQL Server on a 64 bit Windows 2008 Server!

 

Upgrading from a 32 bit to 64 bit SQL-server is NOT a supported upgrade path by Microsoft, so when the day comes that the SQL-databases grow beyond the maximum limit (4/10 GB), the whole Vault server has to be reinstalled.

 

 

 

 

 

 

Distinguished Contributor
xdumont
Posts: 171
Registered: ‎03-20-2006
Message 2 of 5 (408 Views)

Re: Vault installs 32 bit SQL Express

09-04-2012 07:14 AM in reply to: hans.martin.haga

200% agree with you.

Board Manager
ihayesjr
Posts: 558
Registered: ‎02-01-2006
Message 3 of 5 (379 Views)

Re: Vault installs 32 bit SQL Express

09-05-2012 10:14 AM in reply to: hans.martin.haga

Hi Hans,

 

Thanks you for your feedback on this.  Every year we evaluate our installation scenarios and we try to proceed with the best options we have available do to our different installation options.  As 64-bit operating systems become the norm, we will evaluate what we have to do to make a change in the future.

 

If you are upgrading from SQL 32-bit to 64-bit the entire Vault Server doesn't need to be re-installed.

You can uninstall SQL 32-bit, install SQL 64-bit using the Advanced Configuration Guide and lauch the previously installed ADMS Console.  You can perform a restore of the backup, recommended prior to uninstalling SQL 32-bit, and it will install in the SQL 64-bit installation.



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

Valued Contributor
Daryl.Pilarski
Posts: 54
Registered: ‎09-12-2003
Message 4 of 5 (339 Views)

Re: Vault installs 32 bit SQL Express

09-13-2012 05:02 PM in reply to: hans.martin.haga

Dear Hans,

I am very curious on exactly how to do this? I have 2012 Vault Basic running on a XP-Pro 32-bit SQL 2005 and I am trying move my Vault onto a brand new server Running 2013 Vault Basic, Windows 7-Pro 64-bit, SQL 2008 r2 Express.  I cannot get my backup file from the 2012 Server to Restore onto the 2013 machine.  The message I receive is:

  “”…The Database or Backup is not compatible with the database server.  This error May be caused by restoring or attaching files from a version of SQL Server that is higher than the version of your SQL server…””

But as you can see I’m actually going from SQL 2005 to SQL 2008 r2 Express.

 

Thank you,

 

Daryl

Board Manager
ihayesjr
Posts: 558
Registered: ‎02-01-2006
Message 5 of 5 (334 Views)

Re: Vault installs 32 bit SQL Express

09-13-2012 05:47 PM in reply to: Daryl.Pilarski

Daryl,

 

If your SQL 2005 version is not SQL Express you cannot upgrade to SQL Express 2008.  If you have SQL 2005 Standard you must upgrade to a Standard or higher edition of 2008.



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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 to get help installing your software.

Ask the Community