Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Setup, Upgrade, Administration and Operation > WSS 3.0: Upgrade SQL Server 2000 to SQL Server 2005
Ask a questionAsk a question
Search Forums:
 

AnswerWSS 3.0: Upgrade SQL Server 2000 to SQL Server 2005

  • Monday, November 02, 2009 6:25 PMlycan2k8 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi,

    I have WSS 3.0 databases installed on SQL Server 2000.

    Now I'm planning to upgrade the server (stay in the same machine, same name, same instances..) to SQL Server 2005.

    Is there anything I should do regarding SharePoint? Or SharePoint is smart enough? :)

    Thanks
     

Answers

  • Tuesday, November 03, 2009 11:38 AMssm225in Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Hi,

    I would suggest you to disconnect the SQL server from the farm and then do the upgrade. There are two ways of doing the SQL upgrade..
    1>in-place upgrade
    2> side -by - side upgrade

    I guess, you will be going ahead with in-place upgrade. Once this is done, you just connect the SQL server back to the farm and it should work fine without any issues.

    Regards,

     

     
  • Wednesday, November 04, 2009 6:16 AMLily WuMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Hi

    I agree with ssm225in.

    Besides upgrading from SQL server 2000 to 2005 on the same server, you don’t need to do anything regarding WSS 3.0.

    By the way, please be aware that always perform a backup before any upgrade action being executed.
     
    For details about backup databases, please refer to:
    http://technet.microsoft.com/en-us/library/cc671616.aspx

    Best Regards!

     

All Replies

  • Monday, November 02, 2009 6:51 PMMike Walsh MVPMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    It's smart enough but it's a procedure with many steps.

    See this 

    http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/DispForm.aspx?ID=138

    "Databases: How do you move a WSS 3.0 database to a different SQL Server? "

    with info on how (and when) to detach and attach the databases etc.
    FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
    Complete Book Lists (incl. foreign language) on each site.
     
  • Monday, November 02, 2009 11:11 PMlycan2k8 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I'm not moving the database. I'm simply upgrading SQL Server from 2000 to 2005 and wondering if that will have an impact on SharePoint
     
  • Tuesday, November 03, 2009 11:38 AMssm225in Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Hi,

    I would suggest you to disconnect the SQL server from the farm and then do the upgrade. There are two ways of doing the SQL upgrade..
    1>in-place upgrade
    2> side -by - side upgrade

    I guess, you will be going ahead with in-place upgrade. Once this is done, you just connect the SQL server back to the farm and it should work fine without any issues.

    Regards,

     

     
  • Wednesday, November 04, 2009 6:16 AMLily WuMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    Hi

    I agree with ssm225in.

    Besides upgrading from SQL server 2000 to 2005 on the same server, you don’t need to do anything regarding WSS 3.0.

    By the way, please be aware that always perform a backup before any upgrade action being executed.
     
    For details about backup databases, please refer to:
    http://technet.microsoft.com/en-us/library/cc671616.aspx

    Best Regards!