Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SP site and database migration

  Asked By: Leland    Date: May 25    Category: Sharepoint    Views: 666

What's the best way or what are my options to migrate a SharePoint site to
another server? Also, I would like to move the SP database to a different
server and attach the newly migrated SP site to the newly migrated SP

I have tried exporting the SP database using SQL Server Enterprise Manager.
Then create the site using the migrated SP database but I keep getting
"Database 'database_name' already exists (error ....)" I have executed the
following in SQL Query Analyzer but I still get the error above.

Any advice?



5 Answers Found

Answer #1    Answered By: Ira Knox     Answered On: May 25

I use the backup and restore function for sharepoint.

It works fine...as long as they are both the same
version and service packs.

Are we talking about 2001 ---> 2003 migration  or just
the same puppy but a different location...???

Answer #2    Answered By: Divyesh Hurkadli     Answered On: May 25

Moving from one server  (SP Services + MSDE) to 2 servers (SP Services on one
server, and sql  Server 2000 on another).

Same version of everything. Just different boxes.

I've seen the backup and restore function of FrontPage. However, that would
mean moving each site  individually. We're looking into deploying all of
them at one time, if possible. I have tried the article on technet.
sharepoint/movewsdb.mspx However, I keep getting "The IIS application pool
user name is invalid." when I set the configuration database  in Windows
Sharepoint Services (see article).

Any ideas? Can you please be more detailed in your reply? I'm a SharePoint

Answer #3    Answered By: Darryl Nguyen     Answered On: May 25

When you say SP services are you meaning.
windows sharepoint  services or SharePoint Portal

How many documents...how many sites....what type of

The book I am referring to is

SharePoint Products and Technologies
Resource Kit.

There is also a new one called
Windows SharePoint Services

Become familiar with both...it is essential to make a
good migration  of data from SharePoint.

This yahoogroup is not a cookbook site..but if
something is easily answere people will help...but you
have a big job ahead of you.

Answer #4    Answered By: Tom Pruitt     Answered On: May 25

I mean Windows SharePoint Services...............

Answer #5    Answered By: Sammie Lancaster     Answered On: May 25

Oh if you want to migrate  a windows SharePoint site

you use the stsadmin command

Google it and you will find the page...I will send you
a help screen from a dos prompt ...what you will get

stsadm.exe -o backup -url http://server/site -filename
backup.dat -overwrite

you will find how to restore also when you google

Didn't find what you were looking for? Find more on SP site and database migration Or get search suggestion and latest updates.