locked
SQL 2008 Upgrade from 2005 RRS feed

  • Question

  • I upgraded to 2008 R2, however the 2005 sql is still loaded.  Do I need to uninstall or leave as is?
    Saturday, August 21, 2010 2:49 PM

Answers

  • Hi Ronnie,

     

    There are two kind of upgrade when you upgrade SQL Server 2005 to SQL Server 2008 R2: side-by-side upgrade and in-place upgrade.

     

     

    ·         If we use in-place upgrade, all SQL Server 2005 service will be upgraded to SQL Server 2008 R2, there will have no any SQL Server 2005 instances or services. The data of SQL Server 2005 will be transferred to SQL Server 2008 R2 also.

     

    ·         If we use side-by-side upgrade, a new instance of SQL Server 2008 R2 will be created and SQL Server 2005 services are still there. But Shared Components will be upgraded to SQL Server 2008 R2.  

     

    Since your SQL Server 2005 is still loaded, we assume you upgraded your SQL Server using side-by-side upgrade. (If not, please correct me). According to your question, if you do not need the data (table, index, login .etc) in SQL Server 2005,please uninstall it. However, if you want to keep the data in SQL Server 2005,you could transfer them to SQL Server 2008 R2.  

     

    If you have any other questions, please feel free to ask.

     

    Thanks,

    Grace

    • Marked as answer by YoYo Yu Wednesday, September 1, 2010 5:00 AM
    Tuesday, August 24, 2010 6:09 AM
  • Ronnie

    In addition to others, do you have 2008 R2 on the same server as an instance? Then if you remove a default SQL Server 2005 instance  you will be remained in named instance , it does not change from named to default.... It is OK, but then you need to run SQL Server Browser that translates the port into a instance,(security ??)


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by YoYo Yu Wednesday, September 1, 2010 5:00 AM
    Tuesday, August 24, 2010 9:07 AM

All replies

  • Hi Ronnie,

    Did you upgrade SQL 2005 to SQL 2008 R2? if so, you wont see SQL 2005 services.

    If you installed 2008 R2 named instance on server which is already running with SQL 2005 and moved all databases from SQL 2005 to 2008 R2, yes please remove 2005 instance.


    Ramesh S
    www.sequalserver.com
    Sunday, August 22, 2010 6:11 AM
  • Hi Ronnie,

     

    There are two kind of upgrade when you upgrade SQL Server 2005 to SQL Server 2008 R2: side-by-side upgrade and in-place upgrade.

     

     

    ·         If we use in-place upgrade, all SQL Server 2005 service will be upgraded to SQL Server 2008 R2, there will have no any SQL Server 2005 instances or services. The data of SQL Server 2005 will be transferred to SQL Server 2008 R2 also.

     

    ·         If we use side-by-side upgrade, a new instance of SQL Server 2008 R2 will be created and SQL Server 2005 services are still there. But Shared Components will be upgraded to SQL Server 2008 R2.  

     

    Since your SQL Server 2005 is still loaded, we assume you upgraded your SQL Server using side-by-side upgrade. (If not, please correct me). According to your question, if you do not need the data (table, index, login .etc) in SQL Server 2005,please uninstall it. However, if you want to keep the data in SQL Server 2005,you could transfer them to SQL Server 2008 R2.  

     

    If you have any other questions, please feel free to ask.

     

    Thanks,

    Grace

    • Marked as answer by YoYo Yu Wednesday, September 1, 2010 5:00 AM
    Tuesday, August 24, 2010 6:09 AM
  • Ronnie

    In addition to others, do you have 2008 R2 on the same server as an instance? Then if you remove a default SQL Server 2005 instance  you will be remained in named instance , it does not change from named to default.... It is OK, but then you need to run SQL Server Browser that translates the port into a instance,(security ??)


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by YoYo Yu Wednesday, September 1, 2010 5:00 AM
    Tuesday, August 24, 2010 9:07 AM