SQLServer 2008 Express to Standard Upgrade
-
We have a vendor installed application that installed SQLServer 2008 Express with a named instance. I just completed an upgrade from Express to Standard edition, but the database is still showing as 'Microsoft SQL Server Express Edition'. Can anyone give me directions on how to switch the instance to a standard edition? We need to be able to use SQLServer agent for backups and other routine maintenance. Thanks, Tim
-
We have a vendor installed application that installed SQLServer 2008 Express with a named instance. I just completed an upgrade from Express to Standard edition, but the database is still showing as 'Microsoft SQL Server Express Edition'. Can anyone give me directions on how to switch the instance to a standard edition? We need to be able to use SQLServer agent for backups and other routine maintenance. Thanks, Tim
Hi, Few additional questions: - Where do you see the Express Edition text? If it's the tools, they may still be Express versions - What does the errorlog say? In the beginning you have the version info from the dbms itself, is it also Express? mika
The need to optimize rises from a bad design.My articles[^]
-
We have a vendor installed application that installed SQLServer 2008 Express with a named instance. I just completed an upgrade from Express to Standard edition, but the database is still showing as 'Microsoft SQL Server Express Edition'. Can anyone give me directions on how to switch the instance to a standard edition? We need to be able to use SQLServer agent for backups and other routine maintenance. Thanks, Tim
Is it simply the name of the instance?
-
We have a vendor installed application that installed SQLServer 2008 Express with a named instance. I just completed an upgrade from Express to Standard edition, but the database is still showing as 'Microsoft SQL Server Express Edition'. Can anyone give me directions on how to switch the instance to a standard edition? We need to be able to use SQLServer agent for backups and other routine maintenance. Thanks, Tim
It's possible your upgrade just installed the standard version alongside the express, with its own named instance. That's what the R2 Express edition did to my machine. Using the management tools, look for another instance on the host. If you find another, export the databases from the express version, then import them to the new one.
Will Rogers never met me.