Saturday, February 20, 2010

Backup and Restore SharePoint site collection from one Farm to another Farm using STSADM commands

Scenario: I have server called “ABC” where there is site collection called http://abc.com and I want to backup this site collection and restore it to new SharePoint farm “XYZ” http://xyz.com
Source Server:
Server Name: ABC
Site Collection URL: http://abc.com
Site Owner: ABC/administrator
Take backup using following command:
STSADM.EXE –o backup –URL http://abc.com -filename “backup_abc.bak” –overwrite
Help URL for backup: http://technet.microsoft.com/en-us/library/cc263441.aspx
Now to restore it to destination SharePoint farm
Destination Server:
Server Name: XYZ
Site Collection URL: http://xyz.com
Site Owner: XYZ/administrator
Create blank Web Application from Central Administration
Now restore using STSADM command
STSADM.EXE –o restore –URL http://xyz.com -filename “backup_abc.bak” –restoremethod New –newdatabaseserver “DATABASE_SERVER_NAME”
Change the site collection owner of this newly restored site
More details for restore is here
http://technet.microsoft.com/en-us/library/cc262087.aspx
Hope this will help you, let us know your comments on it

SharePointKings Team.

4 comments:

Anonymous said...

Nice Post!!!

I was restored the collection Site without problems, and changed the site collection administrators too.

But I can't to browse the site :(

Any Idea???

PACO_MO

SharePoint Kings said...

@PACO_MO,

whats the error you are getting?

Anonymous said...

Hi!! I look in the Sharepoint LOG and Found This:
/******************************/
11/05/2010 10:42:00.32 STSADM.EXE (0x0614) 0x0604 Windows SharePoint Services General 72kg High #20015: Cannot open "core.es-ES.resx": no such file or folder.
11/05/2010 10:42:00.32 STSADM.EXE (0x0614) 0x0604 Windows SharePoint Services General 72kg High (#2: Cannot open "core.es-ES.resx": no such file or folder.)
11/05/2010 10:42:00.32 STSADM.EXE (0x0614) 0x0604 Windows SharePoint Services General 8e26 Medium Failed to open the language resource keyfile core.
/*********************************/

So, I can see the problem was the language pack.

After apply that, the Site Can browse it!!!

Thanks.

PACO_MO

SharePoint Recovery said...

I was little bit doubt in using STSADM commands. I am surfing the internet & found your site. All useful information regarding SharePoint is available on your site. Thanks for sharing this useful information!!




Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to sharepointkings@gmail.com with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to sharepointkings@gmail.com