locked
Upgrade from SQL Server 2008 (win 7 professional) to SQL Server 2008 R2 (win 7 professional) RRS feed

  • Question

  • Hi,

    I have SQL Server 2008 standards running on Win 7 Professional. I must update to SQL server 2008 R2 to be able to restore a business contact manager database that was created with SQL server 2008 R2 (business contact manager with SQL server 2008 cannot restore a database that was created with SQL server 2008 R2). Surpringly, win 7 professional does not offer the automatic update from SQL server 2008 to SQL 2008 R2. Hence, I tried to update it manually, and when I do I get an error indicating that such update is not currently supported and refers me to the SQL server 2008 R2 upgrade matrix (http://msdn.microsoft.com/en-us/library/ms143393.aspx). The only version of SQL server 2008 that does not support the upgrade to R2 is the evaluation version. I have a full, legal copy of win pro (I just purchased with a new laptop). Hence, my SQL 2008 shoud be recognize as a full legal version, not "evaluation". Does anyone know how to convince the R2 setup program to treat my SQL server 2008 version as a "standard" version so that it can complete the upgrade or does anyone know how to solve this problem?

    Thanks. 

    Monday, December 26, 2011 2:53 AM

Answers

  • The version of SQL Server you're using has nothing to do with the OS installed on your laptop.  Just because you have a legal copy of Win 7 Professional does not mean that you have a licenced copy of SQL Server 2008 Standard Edition.  Given this, you are more than likely using the Evaluation Edition of SQL Server 2008 which cannot be upgraded to SQL Server 2008R2.
    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    • Proposed as answer by Naomi N Wednesday, December 28, 2011 4:07 AM
    • Marked as answer by Maggie Luo Thursday, January 5, 2012 5:18 AM
    Wednesday, December 28, 2011 3:40 AM

All replies

  • Do you have a CD of SS2008R2? Do you have SS2008R2 installed on your machine? If yes, just backup\restore the database

    BTW, if the database is less than 10GB , you can install (free) SQL Server 2008r2 EXPRESS edition side by side with your SQL Server 2008


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, December 26, 2011 7:49 AM
    Answerer
  • Hi rumba,

    For all editions except express edition of SQL Server 2008 running on Windows 7, you must have at least SQL Server 2008 Service Pack 1 (SP1) installed. Express edition already includes Service Pack 1. Please check if you have installed Service Pack 1.

    How to upgrade to SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms144267.aspx.

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, December 27, 2011 7:01 AM
  • The version of SQL Server you're using has nothing to do with the OS installed on your laptop.  Just because you have a legal copy of Win 7 Professional does not mean that you have a licenced copy of SQL Server 2008 Standard Edition.  Given this, you are more than likely using the Evaluation Edition of SQL Server 2008 which cannot be upgraded to SQL Server 2008R2.
    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    • Proposed as answer by Naomi N Wednesday, December 28, 2011 4:07 AM
    • Marked as answer by Maggie Luo Thursday, January 5, 2012 5:18 AM
    Wednesday, December 28, 2011 3:40 AM
  • Hi rumba,

    For all editions except express edition of SQL Server 2008 running on Windows 7, you must have at least SQL Server 2008 Service Pack 1 (SP1) installed. Express edition already includes Service Pack 1. Please check if you have installed Service Pack 1.

    How to upgrade to SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms144267.aspx.

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    SQL Server 2008 Evaluation Edition cannot be upgraded http://msdn.microsoft.com/en-us/library/ms143393.aspx
    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    Wednesday, December 28, 2011 3:41 AM