Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Best way to move a site collection

  Asked By: Ciera    Date: Oct 02    Category: Sharepoint    Views: 3564

I have a site collections running at http://severname:port/ on farm 1
and I now want to move it to http://servers/sites/sc name on farm 2.

Is the best way to backup/restore? Will I have problems with the
content db or will it merge into the existing content db I have on farm

I have tried to create a site template but it is too large. After
reading thru the new best practices book I remember there is a stsadm
cmd to increase the allowed size of site templates.

What is the best method to do this move?



6 Answers Found

Answer #1    Answered By: Hema Pasupuleti     Answered On: Oct 02

If you're moving an entire site  collection your best (and only) method
is to back it up with "stsadm -o backup -filename" and then use "stsadm
-o restore -filename" to restore it to the new location.

Answer #2    Answered By: Candis Kinney     Answered On: Oct 02

You could also do this I believe:

When I first heard about it, I had to test the simplicity to do this
with the new stsadm option that was inserted in the latest security
hotfix for WSS of October 9th. This command is not very well documented
anywhere. I heard about it by Todd Klindt in one of his TechEd sessions
last week and tested it today. I must say it works like a charm.

This is the command:

stsadm.exe -o mergecontentdbs
-url <url>
-sourcedatabasename <source database name>
-destinationdatabasename <destination datbabase name>
[-operation <1-3>
1 - Analyze (default)
2 - Full Database Merge
3 - Read from file]
[-filename <file generated from stsadm -o enumsites>]

See also:
stsadm -o enumcontentdbs -url <url>
stsadm -o enumsites -url <url> -databasename <database>

The way this is to be used as suggested by Todd is, to use a file with
the site  collections you want to move. As you can see above this file
can be generated by the stsadm -o enumsites command. All you need to do
then, is open up the file and remove the lines with the site collections
you do not want to move. Save the rest and feed it to the new command.

e.g. C:\stsadm -o mergecontentdbs -url http://wss <http://wss/>
-sourcedatabasename WSS_Content_7fc30dd3c1514cdda6b68bd8d10a0463
-destinationdatabasename WSS_Content -operation 3 -filename sites.txt

So, I hope you enjoy this cool new command and use it !

Answer #3    Answered By: Cora Bradshaw     Answered On: Oct 02

I think I may use a combination. I will do
a backup and restore which will let me change the most of the info
except for the content  db. Then I will move  the site  to my desited
content db and then remove the one that is no longer needed (from the

Does this sound valid?

Answer #4    Answered By: Shushma Zariwala     Answered On: Oct 02

I have tried to restore the backup without much success using CA. I
am chaning the settings and the only thing that happens is the new
database is created but it has 0 sites.

Is there something I am missing?

Answer #5    Answered By: Bahadur Kotoky     Answered On: Oct 02

I just 1. Lock the site  Collection to be backed up 2. Backup via stsadm.exe 3.
take all databases offline, except the one I want the site collection  to reside
4. restore the site collection.

this shoiuld put it in the correct database. Use mergecontentdbs ala big daddy
klindt's blog for multiple site collections  as it will save time.

Answer #6    Answered By: Jeremey Avery     Answered On: Oct 02

Got it working finally. I tried all sorts of options with the gui
restore in CA with no luck getting it exactly like I wanted it. I
should have known not to use the GUI.

Once I stuck with the stsadm commands for backup and restore it works

Didn't find what you were looking for? Find more on Best way to move a site collection Or get search suggestion and latest updates.