Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SQL Server upgrade

  Asked By: Mrigendra    Date: Jun 12    Category: Sharepoint    Views: 550

I am a SharePoint consultant working for a company that has a small
farm toplogy: 2 WFE's - App Server - back end clusted SQL Server. The
SQL Server is still 2000. Now, they want to upgrade to SQL Server 2005.
The DBA has outlined two possible courses of action: (1) Upgrade the
old server in place -- or (2) Install SQL Server 2005 on a new box,
copy the SharePoint DB's to it and point SharePoint to the new DB's via
Central Admin.
Has anyone gone through a simlar SQL Server upgrade? What are the
pros and cons of either approach?



3 Answers Found

Answer #1    Answered By: Jada Clemons     Answered On: Jun 12

We are doing option two this weekend. We are still using sp 2003.

Answer #2    Answered By: Brooke Lewis     Answered On: Jun 12

New box, please. install it offline, give it the same name and IP.
Move databases to new box which will upgrade  them to 2005. Then take
old SQL box offline and put new SQL box online. Should work.

Answer #3    Answered By: Talia Johns     Answered On: Jun 12

I've used the exact process Bill outlined to upgrade  from SQL 2000 to SQL 2005
twice and it worked great both times. One word of advice, disable Full Text
Search in SharePoint before you shut the SQL 2000 box down. FTS saves some
information on the SQL server's local drive and things can get confusing.
Reenable it once you get things up on SQL 2005. You don't mention (or I didn't
see) which SharePoint product you're using or which version, so I can't give
more specific advice.

Didn't find what you were looking for? Find more on SQL Server upgrade Or get search suggestion and latest updates.