none
upgrade sql server 2008 to sql server 2008 r2 which runs sharepoint 2010

    Question

  • hi all,

    i am having a  requirement to upgrade sql server 2008 to sql 2008 r2 without losing content in the sql 2008.

    its a content database of sharepoint 2010.

    due to some issues, i was forced to take a decision to move the content db of sp 2010 from sql 2008 r2 to sql 2008.

    pls help, how can i upgrade without losing content.

    i tried with taking the backup from sql 2008 r2 and restored it in sql 2008. 

    and i tried with generates scripts option and ran that ssis package but in vain.!

    is there any free tools are available to upgrade to sql 2008 R2 without losing any content.

    hep is appreciated

    Sunday, August 18, 2013 5:51 AM

Answers

  • i am having a  requirement to upgrade sql server 2008 to sql 2008 r2 without losing content in the sql 2008.its a content database of sharepoint 2010.

    due to some issues, i move the content db of sp 2010 from sql 2008 r2 to sql 2008.

    i tried with taking the backup from sql 2008 r2 and restored it in sql 2008. 

    is there any free tools are available to upgrade to sql 2008 R2 without losing any content.

    Hi SaMoIPP,

    According to your description,if you want to upgrade sql server 2008 to sql 2008 r2 without losing content . Usually, we choose taking the backup from sql 2008 and restoring it on sql 2008 R2 after upgrading. But for your description of process it is opposite. We cannot restore a laster version backup to a previous version. It is only forward compatible.

    In addition, as other post, we can upgrade to SQL Server 2008 R2 by following the link.

    There is more details about moving a database from one SQL Server instance to another instance after upgrading to the new version of SQL Server. you can review the blog.
    http://www.karaszi.com/sqlserver/info_moving_database.asp

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, August 19, 2013 1:58 AM

All replies

  • Please see these links:

    Considerations for Upgrading the Database Engine

    How to: Upgrade to SQL Server 2008 R2 (Setup)

    How to: Upgrade a Database Using Detach and Attach (Transact-SQL)


    The most important motivation for the research work that resulted in the relational model was the objective of providing a sharp and clear boundary between the logical and physical aspects of database management. - E. F. Codd


    My blog

    Sunday, August 18, 2013 2:10 PM
  • Hello,

    If you would like to upgrade from SQL Server 2008 to SQL Server 2008 R2, you can perform an in-place upgrade using the instructions provided on the following link:

    http://technet.microsoft.com/en-us/library/ms144267(v=sql.105).aspx

    If you would like to downgrade from SQL Server 2008 R2 to SQL Server 2008, you cannot do it. The best option is to restore from a backup created when it was a SQL Server 2008 instance.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, August 18, 2013 3:30 PM
  • i am having a  requirement to upgrade sql server 2008 to sql 2008 r2 without losing content in the sql 2008.its a content database of sharepoint 2010.

    due to some issues, i move the content db of sp 2010 from sql 2008 r2 to sql 2008.

    i tried with taking the backup from sql 2008 r2 and restored it in sql 2008. 

    is there any free tools are available to upgrade to sql 2008 R2 without losing any content.

    Hi SaMoIPP,

    According to your description,if you want to upgrade sql server 2008 to sql 2008 r2 without losing content . Usually, we choose taking the backup from sql 2008 and restoring it on sql 2008 R2 after upgrading. But for your description of process it is opposite. We cannot restore a laster version backup to a previous version. It is only forward compatible.

    In addition, as other post, we can upgrade to SQL Server 2008 R2 by following the link.

    There is more details about moving a database from one SQL Server instance to another instance after upgrading to the new version of SQL Server. you can review the blog.
    http://www.karaszi.com/sqlserver/info_moving_database.asp

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, August 19, 2013 1:58 AM
  • Thanks for the reply.

    But   for me, my CEWP, CQWP and the otherr xslt customized  web part using cqwp in the discussions list and

    announcements list have gone. Can you help me how to retrieve that content also.

    Sunday, September 01, 2013 7:54 AM