question

GretaB-9609 avatar image
0 Votes"
GretaB-9609 asked GretaB-9609 commented

I recently upgraded SQL 2012 Express to Standard and am not sure if my exisitng databases upgraded with the SQL instance

I recently upgraded an instance of SQL Server Express 2012 to Standard because my database was reaching its maximum capacity with Express. My question is - do the existing databases within the SQL instance automatically lose the limitations of express and gain the added capacity from the full SQL upgrade? Or do I need to create a brand new database for it to inherit the benefits of Standard?

If I do need to create a new database how do I migrate the old database into the new one? I cannot lose any of the data in my existing database as it is critical for my clients company. Any recommendations are helpful as I am fairly new to SQL.

Thank you!

sql-server-generalsql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered GretaB-9609 commented

How exactly did you "upgrade from Express to Standard"?

If you used Edition or in-place upgrade, then you do not need to do anything. The size limit is enforced by the running edition.

If you did a side-by-side install, then you need to migrate all your databases to the new instance.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I did the Edition Upgrade option under Maintenance in the installation wizard.
Thank you for your help! It appears my SQL upgrade was successful - I just wanted to make sure I was not missing a step.

0 Votes 0 ·
cooldadtx avatar image
0 Votes"
cooldadtx answered

Changing editions of SQL doesn't require any DB changes.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.