AndrewSQLDBA (2/26/2010)
No, you would want to un-install the Express edition first, do not try to "upgrade". That is the very best way to approach this issue.You can create a backup of the databases, and then restore them on the prod box once SQL Server is installed.
Andrew SQLDBA
Hi Andrew,
I get what you are saying ref...backup to disk/tape.....detach DB's.....blow away the previous version and go with the new install etc. However, at this moment I'd find that approach a tad to aggressive for my liking.....simply due to the fact of the downtime required and that who is to say I might not get the same error whilst installing the standard edition. Thanks again....I'm sure that there is another way around this tho.
rgds,
Jay