SQL 2014 Express at 10 Gb limit need to upgrade to SQL Sandard

Issues and questions related to TopSolid installation.

Moderators: remi77, Daniel, jacs

Post Reply
eric14779
Master Corporal
Master Corporal
Posts: 32
Joined: Wed May 05, 2010 1:24 am
TopSolid Module: TopSolid'Design
TopSolid Version: 7.7
Location: Upstate New York (Buffalo)

SQL 2014 Express at 10 Gb limit need to upgrade to SQL Sandard

Post by eric14779 » Tue Dec 27, 2016 1:49 pm

OK.

Got the PDM Database is less than 1 Gb away from the 10Gb limit Please consider upgrading to SQL Standard Edition Warning...

I contacted our outside IT guy and he quoted a price for SQL Server 2016 Standard and User License per each cost.

He also said that we would have to purchase a User Lic. for each TopSolid 7 user.... Is this correct ??? There is only 1 user active in the SQL 2014 Express system currently... It seems that TopSolid 7 funnels everthing thru this one user..


the other question I have is how much time should it take to do a in place SQL upgrade. We have daily full backups.
Last edited by eric14779 on Tue Jan 10, 2017 8:57 pm, edited 1 time in total.

eric14779
Master Corporal
Master Corporal
Posts: 32
Joined: Wed May 05, 2010 1:24 am
TopSolid Module: TopSolid'Design
TopSolid Version: 7.7
Location: Upstate New York (Buffalo)

Re: SQL 2014 Express at 10 Gb limit need to upgrade to SQL Sandard

Post by eric14779 » Thu Dec 29, 2016 3:56 pm

OK

I got my outside IT guy getting SQL 2016 Standard with 1 lic ( had to buy 3 "dummy" lic also.... ?? whatever...)

I was able to delete a couple of unnecessary projects and increase my remaining database space ( in SQL Express ) to 4.2 Mb so we should not have a problem before we get the SQL 2016 upgrade installed.

I will make another post when the upgrade is complete.

eric14779
Master Corporal
Master Corporal
Posts: 32
Joined: Wed May 05, 2010 1:24 am
TopSolid Module: TopSolid'Design
TopSolid Version: 7.7
Location: Upstate New York (Buffalo)

Re: SQL 2014 Express at 10 Gb limit need to upgrade to SQL Sandard

Post by eric14779 » Tue Jan 10, 2017 8:56 pm

Well,

SQL upgrade is complete..... Could not go to SQL 2016 as we have Server 2008 R2 on our PDM server..... so upgraded to SQL 2014 Standard.

No problem with the in-place upgrade, except the SQL database log file got HUGE.... that along with the installer download filled the Hard drive.

Deleted the downloaded installer file, and ran a SQL logfile shrink, and now all is back to normal.... with basically unlimited SQL database size.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests