146 reputation
3
bio website megustaulises.com
location San Antonio, TX
age 30
visits member for 2 years, 8 months
seen Nov 19 at 13:03

I'm a Senior Software Engineer and Agile Practitioner based in San Antonio, TX.

Most of my experience is on the .Net framework and recently java (and Spring).


Apr
17
awarded  Supporter
Aug
2
awarded  Teacher
Apr
24
awarded  Autobiographer
Apr
20
comment How to upgrade sql server express 2005 to 2008R2
I've ran into that before, that's when I uninstall and make sure I'm in control of what I have in the box
Apr
20
comment How to upgrade sql server express 2005 to 2008R2
I was suggesting to uninstall just to make it easier, I thought you were on your development machine. Now that it is clearer what you need to do you can just run the 2008R2 installer and select upgrade. Then pick the SQLExpress instance. I've ran into a few instances in which for whatever reason the instance cannot be upgraded. In that case I uninstall 2005 (no rebooting required)
Apr
20
comment How to upgrade sql server express 2005 to 2008R2
@MuhammadA: SQLExpress is a named instance. You can have only one. Although you may have several "SQL Server Express" instances. At this point, you need to figure out what version the named instance SQLExpress is running (2005,2008,2008R2 or 2012). You can do that by executing "select @@version". In your situation, if it's anything other than 2008R2 uninstall it and then install 2008R2
Apr
20
comment How to upgrade sql server express 2005 to 2008R2
Once you upgrade I believe you may still set a compatibility mode for a previous version of SQL Server; however, your database will still be upgraded. This means that you won't be able to attach it with a 2005 engine.
Apr
19
answered How to upgrade sql server express 2005 to 2008R2