?
Solved

SharePoint 2007 Moving from one server to another

Posted on 2013-01-18
6
Medium Priority
?
499 Views
Last Modified: 2013-03-14
I need to move our current sharepoint site from one server to another server, both running 2007.  I have backed up the current farm.

I am in need of assistance in moving them to the other server.  What  would the steps be?
0
Comment
Question by:murphybrown22
  • 3
  • 2
6 Comments
 
LVL 10

Expert Comment

by:Mohit Nair
ID: 38794778
If you have same versions of sharepoint installed on both different servers or farms then create a web app on destination server with some test database.Detach the test database once web app is created and simply attach the moved content database and attach it on destination server via stsadm addcontentdb command.
0
 

Author Comment

by:murphybrown22
ID: 38794785
I'm a little new to database detachment.  What would the steps be to do this?  Also.  The current configuration is running from SqL 2005 and it's moving to SQL 2008.  Is this okay?
0
 
LVL 10

Expert Comment

by:Mohit Nair
ID: 38794835
Yes its ok. You can take a backup of SQL content database from SQL 2005. Just right click on database > go to tasks > backup. This will help to take database backup.
Once backup is done go to SQL 2008 and right click on system databases and click on restore.
Give the database a name. Restore done successfully.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 13

Accepted Solution

by:
Yagya Shree earned 1500 total points
ID: 38795774
Please follow below Microsoft recommendation while doing a SharePoint 2007 Farm migration to be in support environment

Move and migrate servers and server farms (Office SharePoint Server 2007)
http://technet.microsoft.com/en-us/library/cc262370%28v=office.12%29.aspx

Move all databases (Office SharePoint Server 2007)
http://technet.microsoft.com/en-us/library/cc512725%28v=office.12%29.aspx

SharePoint 2007 Farm Migration
http://davidlimsharepoint.blogspot.in/2010/04/sharepoint-2007-farm-migration.html

Migration - Move SharePoint 2007 from 1 server farm to another
http://blogs.msdn.com/b/priyo/archive/2006/09/15/755490.aspx
0
 

Author Comment

by:murphybrown22
ID: 38802196
Screenshot of what occured when I tried to restore the database fileI did the backup and restore of the individual databases and I got this below:...where did I go backwards?
0
 

Author Comment

by:murphybrown22
ID: 38814507
Doing the backup and restore can only be done after I do a web application on the new server correct?
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface There are many applications where some computing systems need have their system clocks running synchronized within a small margin and eventually need to be in sync with the global time. There are different solutions for this, i.e. the W3…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question