Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Changing SQL Server in a small farm

  Asked By: Rozi    Date: Dec 27    Category: Sharepoint    Views: 1015

I have a SPS 2003 small server farm deployment, with one server running SPS and
one running SQL Server 2000. The SQL administrators want to move all databases
from that server to another server (with a different name). How can I rebuild my
farm using this new server as the database server ?



2 Answers Found

Answer #1    Answered By: Deana Lowery     Answered On: Dec 27

It's pretty straight forward. First, your DBA will backup and then
restore the databases to the new server. Be sure he gets all 4
databases: prof,serv,site, and config. Next, go into SharePoint
Portal server  Central Administration page. Go to the Configure server
topology page (it's the first option). There you will see a list of
all the databases. Just select each and change them to point to the
new DBs. I've done this many times and it seems to work fine.

Answer #2    Answered By: Felecia Goff     Answered On: Dec 27

I eventually succeeded, but it was not as straight forward as that...
First of all I had to modify the location of the content database server, then
the component settings DB server, and then modify the configuration DB server.
And if I wanted to do that, I had to disconnect my SPS server  from the existing
configuration DB first; and before that, I had to remove the active components
running on my SPS server (and that means reinitializing my indexes); then I had
to connect to the new config DB on the new server and restart the Web, Search
and Index components. Also, for a reason unknown to me, I had to stop/restart
IIS in order to make it work.
So, would I have a configuration problem ? According to SPS itself, "my farm  is

Didn't find what you were looking for? Find more on Changing SQL Server in a small farm Or get search suggestion and latest updates.