locked
Sharepoint 2010 with SQL 2005 sp3 RRS feed

  • Question

  • Dear all

    i have sp2007  on 2008 r2 with sql server 2003 sp3 now i have a new server with 32gb ram rack mounted dell. i want to install SP2010 with Sql 2005 sp3 32 bit

    first i installed sql 2005 and applied sp3 then insatlled sp2010 on 64 w2k8 R2 in an single server how to migrate all my existing data in to a new server

    any step by step procedure available for successful migration? Please ...

    God Blessing........!

     

     

     


    RaSa
    Saturday, November 6, 2010 6:41 PM

Answers

  • RaSa,

    It sounds like you have two Standalone SharePoint Servers.  One is running MOSS 2007 and one is running SharePoint 2010.  The server running MOSS 2007 is running 32-bit SQL Server 2005 while the SharePoint 2010 Server is running 64-bit SQL Server 2005.

    If this is correct I would suggest performing the following steps:

    1) Ensure your MOSS 2007 Farm is patched to SP2.  This means you'll need to install WSS 3.0 SP2 first and then MOSS 2007 SP2.

    2) Next, run the pre-upgrade checker:

    1. Verify that you have the following administrative credentials:

      • To use Stsadm, you must be a member of the local Administrators group on the server.
    2. Click Start, right-click Command Prompt, and then click Run as administrator.

    3. In the Command Prompt window, navigate to the following directory:

      %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\12\bin

    4. Type the following command and press ENTER:

      STSADM.EXE -o preupgradecheck

    Reference: http://technet.microsoft.com/en-us/library/cc262231.aspx

    To migrate your content databases you'll want to back up the databases, copy them to the SQL Server 2005 x64 Server and reattach the databases.  The complete process is document here:

    http://technet.microsoft.com/en-us/library/cc263299.aspx

     

     

     


    Dennis Bottjer | Follow Me: @dbottjer | Blog: Dennis Bottjer.com
    • Marked as answer by GuYuming Friday, November 12, 2010 6:52 AM
    Sunday, November 7, 2010 4:33 AM
  • According to http://technet.microsoft.com/en-us/library/cc262485.aspx , you need to use 64bit of SQL Server instead of 32bit.

    • Marked as answer by GuYuming Friday, November 12, 2010 6:52 AM
    Monday, November 8, 2010 2:31 AM

All replies

  • RaSa,

    It sounds like you have two Standalone SharePoint Servers.  One is running MOSS 2007 and one is running SharePoint 2010.  The server running MOSS 2007 is running 32-bit SQL Server 2005 while the SharePoint 2010 Server is running 64-bit SQL Server 2005.

    If this is correct I would suggest performing the following steps:

    1) Ensure your MOSS 2007 Farm is patched to SP2.  This means you'll need to install WSS 3.0 SP2 first and then MOSS 2007 SP2.

    2) Next, run the pre-upgrade checker:

    1. Verify that you have the following administrative credentials:

      • To use Stsadm, you must be a member of the local Administrators group on the server.
    2. Click Start, right-click Command Prompt, and then click Run as administrator.

    3. In the Command Prompt window, navigate to the following directory:

      %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\12\bin

    4. Type the following command and press ENTER:

      STSADM.EXE -o preupgradecheck

    Reference: http://technet.microsoft.com/en-us/library/cc262231.aspx

    To migrate your content databases you'll want to back up the databases, copy them to the SQL Server 2005 x64 Server and reattach the databases.  The complete process is document here:

    http://technet.microsoft.com/en-us/library/cc263299.aspx

     

     

     


    Dennis Bottjer | Follow Me: @dbottjer | Blog: Dennis Bottjer.com
    • Marked as answer by GuYuming Friday, November 12, 2010 6:52 AM
    Sunday, November 7, 2010 4:33 AM
  • Dear Dennis bottjet,

    Thanks for your response.

    I am not upgrading on the same system instead i have another better server where i have installed R2 os/sp2010/sql server 2005 32 bit with sp3 in a new server i have created a new web appllication site which is working but it stores the content in SQL2008 which a a part for sp2010 setup.

    so what i want is when sites are created in the new server the  contentdb should be created in sql 2005 sp3 forthis i have created a same GUID DB in sql2005 and re-attach the Contentdb is fine and successfull when i browse that site it does not show anything.

    those site are customised sites.

    another question is when installing sp can i change the location of setup instead of C drive

    i need to run in different location

    God blessings...


    RaSa
    Sunday, November 7, 2010 6:01 AM
  • According to http://technet.microsoft.com/en-us/library/cc262485.aspx , you need to use 64bit of SQL Server instead of 32bit.

    • Marked as answer by GuYuming Friday, November 12, 2010 6:52 AM
    Monday, November 8, 2010 2:31 AM