MOSS:Back up and Restore Site Collection / Sites Using STSADM Utility Export / Import

STSADM.EXE utility export and import operations are used to backup and restore site collections and sites. These operations are limited to site collections and sites only.  

STSADM.EXE is usually located at “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN”. No GUI interface for the STSADM utility is available. The old and trusted command line is used for the utility. 

The backup contains library content, list content, navigation, user information, security settings, personalize settings like views and content types and customization but does not contain alerts, workflows and properties.  

BACKUP 

For backup, we use export operation which has the following syntax: 

stsadm -o export 

-url <URL name>

-filename <export file name>

[-overwrite]

[-includeusersecurity]

[-haltonwarning]

[-haltonfatalerror]

[-nologfile]

[-versions] <1-4>

[-cabsize] <integer value>

[-nofilecompression]

[-quiet] 

Parameter Description
url URL of the site collection / site
filename Name of the backup file
overwrite Overwrite the already existed backup file
includeusersecurity Maintain the security settings
haltonwarning Stop the export operation when a warning occur
haltonfatalerror Stop the export operation when an error occur
nologfile No log file will be generated at the end of the export operation.
versions Values ranges from 1 to 41-          Default value, last major versions of the files and list items included.2-          The current version, either the major or the last minor version included.3-           Last major and last minor version of the files and list items included.4-          All versions of the files and list items included.
cabsize Value ranges from 1 to 1024. set the total size of cabinet file. Once  size limit is reached, another cabinet file is created.
nofilecompression Disable file compression. If compression is allowed, export operation can increase by 30%
quiet Export operation information will not be displayed and operation will end with success message.

The command that I use to run is  

stsadm –o export –url htpp://URL –filename E:\backup\test.cab –includeusersecurity –versions 4 –cabsize 1024 –nofilecompression  

This command will create a directory test.cab. 

RESTORE 

First you have to create an empty website to restore. This can be done using Microsoft Office SharePoint Designer 2007.

For this, open Microsoft Office SharePoint Designer 2007 and move from File menu to New and click on Web Site. In the New Dialog box, select Web Site tab, then select General and then Empty Web Site. Give the desired URL  in the text box at the bottom of the dialog box and click OK. Microsoft Office SharePoint Designer 2007 will create a new empty web site.  

To restore, we use import operation which has the following syntax: 

stsadm -o import

-url <URL name>

-filename <import file name>

[-includeusersecurity]

[-haltonwarning]

[-haltonfatalerror]

[-nologfile]

[-updateversions] <1-3>

[-nofilecompression]

[-quiet] 

Parameter Description
url URL of the site
filename Name of the restore file
includeusersecurity Maintain the security settings
haltonwarning Stop the export operation when a warning occur
haltonfatalerror Stop the export operation when an error occur
nologfile No log file will be generated at the end of the export operation.
updatversions Values ranges from 1 to 31       Default value, will add new version to the current file.2        Overwrite the file and all of its versions.3       Ignore the file if it exists of the destination.
nofilecompression Either enables or disables file compression in the import package. The import package is stored in the folder specified by the -filename parameter. It is recommended to use this parameter for performance reasons. If compression is enabled, it can increase the import process by approximately 30%.
quiet Export operation information will not be displayed and operation will end with success message.

The command that I use to run is  

stsadm –o import –url htpp://URL –filename E:\backup\test.cab –includeusersecurity –updateversions 3  –nofilecompression  

Exception: 

Error occurred while exporting the web http://site URL

Access is denied.(Eception from RESULT:0x8007005(E_ACCESSDENIED)) 

Reason: 

You are not the administrator of the site collection. 

Resolution: 

Add yourself as site administrator. For this, open SharePoint Central Administration. Move from “Application Management” to “Site collection administrators” under  “SharePoint Site Management”. Add yourself as administrator in the appropriate site collection. 

 

http://office.microsoft.com/download/afile.aspx?AssetID=AM102424831033

 

http://technet2.microsoft.com/Office/en-us/library/1178aa35-20b1-45b0-bcb6-4249aa34ea481033.mspx?mfr=true

 

http://technet2.microsoft.com/Office/en-us/library/65788bb9-0345-42c8-a216-e99e558b173d1033.mspx?mfr=true

 

 

Advertisements

14 Comments »

  1. Tariq Younas said

    Sites are moving using above commands.
    But in this procedure is layout and look and feel is not exported on other server.
    Is there anyway to include them.

  2. Pungi said

    Wonder how you’re export’s working with this protocol: “htpp://URL” ?

  3. Farhan Faiz said

    Pungi,

    Plzzzz don’t wonder. Just replace http://URL with desired URL 🙂

    Regards,

  4. Anil said

    Hi Farhan,

    Thanx for the article, its really help me.

  5. ashwini said

    I just need to take a backup of the one site from development server and restore it on production server, but it is not restoring page layouts and the properties of webparts which i have created in sharepoint designer ,Any solution for this problem?

  6. Bala said

    how the above article hepls to deploy the sharepoint site on the client computer.

    please let me know the software requirements(software and hardware) on client system

    please help me in detail steps as am very new to this technology

    waiting for u’r response…thanks in advance

    • Farhan Faiz said

      STSADM is already available on MOSS server. You can find it at C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

  7. Edward said

    Again does not work. “command line error”

  8. Edward said

    No switch beyond filename is permitted
    so command that works is ‘stsadm -o export -url “https://xxxx/viewnet/railgun” -filename “C:\Documents and Settings\me\My Documents\Templates\railcopy.cab” ‘

  9. rioniocur said

    “In the New Dialog box, select Web Site tab, then select General and then Empty Web Site. Give the desired URL in the text box at the bottom of the dialog box and click OK. Microsoft Office SharePoint Designer 2007 will create a new empty web site.”
    Intresting. I would like details!

    • Farhan Faiz said

      What kind of details?

  10. newbee said

    Hi, I am able to export my sitecollection successfully.
    But when I am trying to import the same on another sharepoint server into a new sitecollection, I am having the following error .

    stsadm -o import -url http://prod-server-name:port -filename drive:\foldername\file.cmp -includeusersecurity.

    The web application at http://prod-server-name:port could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

    Any suggestions please ? This is on SharePoint 2010.

    Appreciate your help

    Thank you

    • Farhan Faiz said

      That seems to be access issue. Does your account has enough permissions? You can verify it by using different accounts.

  11. We are a group of volunteers and opening a brand new scheme in our community. Your website provided us with valuable info to work on. You’ve performed an impressive job and our entire group shall be thankful to you.

RSS feed for comments on this post · TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: