Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint, EPM, REPORTING SERVICES Database Migration To New Server

  Asked By: Dana    Date: Nov 10    Category: Sharepoint    Views: 11363

We had a single server on which the following stuff was installed.

1. SPS 2003
2. SQL SERVER 2000
We are using both RDBMS and OLAP component.
3. EPM
4. Reporting Services

Now we have decided to have two servers due to space and performance constraint.

We want to migrate the databse component to the new server.

Please pass on any tips/checklist/documents/performance tuning tips you have .

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Hema Hegde     Answered On: Nov 10

I believe that if you move the database  to another server  you must also create a
separate Index/Job server. I don't believe that there is a two server SharePoint
topology.

 
Answer #2    Answered By: Damon Garner     Answered On: Nov 10

We do run a two job farm :-) We just have a second IP added to the interface to then build off of for the Index / Job server  on our web front end.

 
Answer #3    Answered By: Megan Martin     Answered On: Nov 10

i think he meant 2 server  as in 1 being index/job/web and 1 being the sql.

just run a portal backup, uninstall everything from your old main server, reinstall and recreate a content database  pointing to the new database server and run a portal restore. portal backup is like an ISO of your portal (with the exception of the actual file system).

hope that helps,

 
Answer #4    Answered By: Donta Kirkland     Answered On: Nov 10

I guess i did not communicate properly.

We have one server  on which all the apps mentioned are installed.

The client wants to seperate only the sql server to a different server as there is space constraint on the current server.

How do i go about this.

 
Answer #5    Answered By: Cade Velazquez     Answered On: Nov 10

with the exception of using GOOGLE or similar this is it in a nutshell:

just run a portal backup, uninstall everything from your old main server,
reinstall and recreate a content database  pointing to the new database server
and run a portal restore. portal backup is like an ISO of your portal (with the
exception of the actual file system).

i hope that helps you help the client

 

Related Topics:




 

Related Post