Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SharePoint 2007 Moving from one server to another

Posted on 2013-01-18
6
Medium Priority
?
495 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

If, like me, you have a lot of Dell servers in the estate you manage this article should save you a little time. When attempting to login to iDrac on any server I would be presented with two errors. The first reads "Do you want to run this applicati…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
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 …
Suggested Courses

916 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