locked
"Upgrade" from SQL Server 2005 to 2008 RRS feed

  • Question

  • I have an existing CRM 4.0 environment running SQL Server 2005.  The database / SSRS environment is running on one server, and the CRM application is on another.  I would like to replace my 2005 server with 2008.  What is the correct way to do this?  Is there a Microsoft article preferably that describes this?  My theory is:

    1. Turn off CRM application server.

    2. Backup the MSCRM_Config and <org_name>_MSCRM databases. 

    3. Uninstall SQL Server 2005

    4. Install SQL Server 2008 and all updates.

    5. Restore MSCRM_Config and <org_name>_MSCRM datbases

    6. Fire up the CRM app server.

    7.  Off it goes!!!

    I assume this won't work as it sounds to easy.  I have heard people having to run deployment manager, and I've done this moving to new servers, however not sure if that is necessary or not if you shut things down and restore to a new database server running on the exact same physical server.

    Thanks for your input.

    JR

    Wednesday, April 1, 2009 10:24 PM

Answers

  • Here is an article from MSDN on upgrading to SQL Server 2005 that should help.  It is always best to try this in a test environment before applying to production as you can identify potential issues and solutions before doing the upgrade in production.

    http://msdn.microsoft.com/en-us/library/bb677622.aspx

    And additional information for consideration:

    Support for running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008

    http://support.microsoft.com/kb/957053

    I don't believe you should have to uninstall and then install but rather just upgrade the database.  You should be able to select the Upgrade option when you run SQL 2008 install.  If the only thing changing is moving from SQL 2005 to 2008 then it should be fairly painless.  Of course, backup your database, all customizations, export your CRM customization file and try it in a test environment that replicates production first.  
    Best Regards, Donna
    Wednesday, April 1, 2009 10:49 PM

All replies

  • Here is an article from MSDN on upgrading to SQL Server 2005 that should help.  It is always best to try this in a test environment before applying to production as you can identify potential issues and solutions before doing the upgrade in production.

    http://msdn.microsoft.com/en-us/library/bb677622.aspx

    And additional information for consideration:

    Support for running Microsoft Dynamics CRM 4.0 together with Microsoft SQL Server 2008

    http://support.microsoft.com/kb/957053

    I don't believe you should have to uninstall and then install but rather just upgrade the database.  You should be able to select the Upgrade option when you run SQL 2008 install.  If the only thing changing is moving from SQL 2005 to 2008 then it should be fairly painless.  Of course, backup your database, all customizations, export your CRM customization file and try it in a test environment that replicates production first.  
    Best Regards, Donna
    Wednesday, April 1, 2009 10:49 PM
  • 1. Backing up is always a good idea and so is testing it out prior to performing it in production.

    2. Can just upgrade the SQL 2005 without uninstalling it, you can erform the SQL Server 2008 Upgrade Advisor (comes with SQL 2008 DVD) and the System Configuration Checker prior to the upgrade.  MSCRM v4.0 support both SQL Server 2005 and 2008.

    3. Be sure to backup the CRM Reports you may need to republish them after the SQL Server upgrade




    http://www.workopia.com/Links.htm
    Thursday, April 2, 2009 6:00 AM
    Moderator