locked
Backing Up Using Stsadm RRS feed

  • Question

  • I would like to do a back up using Stsadm but I haven't done it in awhile (3 years). we are running MOSS for our Intranet. I'm a better visual and hands-on learner. Are there any screen shots available to download? I have searched Google and Bing with no success. I have no Sandbox or test server to use, everything is done 'production :(.
    Wednesday, July 6, 2011 3:27 PM

Answers

  • Same status as FMorales2!  Although there is a corporate backup process that should be backing up the SP sites and databases, I always like to run monthly backups on my own to have a quick restore path in case our farm should go down, but I set up a few BAT files in my c:/windows directory so I can use one command line code to run a script full of backup steps.  Do the following:

    1.  Create a Bin.bat file in your c:/windows directory.  Content will be:

    cd C:\program files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN (or wherever you have the STSADM file stored)

    2. Create another Bat file in the same location and use commands like this:

    stsadm -o setsitelock -url http://intranet.domain.com -lock noaccess
    stsadm -o backup -url http://intranet.domain.com/ -filename \\nas\sharepoint\restore\intranet.bak -overwrite
    stsadm -o setsitelock -url http://intranet.domain.com -lock none

    stsadm -o setsitelock -url http://intranet.domain.com/subsite-collection/ -lock noaccess
    stsadm -o backup -url http://intranet.domain.com/subsite-collection/ -filename \\nas\sharepoint\restore\intranet-subsite-collection.bak -overwrite
    stsadm -o setsitelock -url http://intranet.domain.com/subsite-collection/ -lock none

    Locking the sites prevents anyone from modifying content during the backup process.  The BAK files are copied to a backup storage solution that is maintained offsite.  This script routine makes it easy from me to backup.  Alternately, the same type of script can be used to RESTORE a site, though you probably wouldn't need to Lock the sites first.

    3. From a Command prompt, type BIN to take you to the SharePoint bin where STSADM is stored.

    4. Type the filename of the second BAT file you created with your STSADM commands.  If you have a MyFileName.bat file in c:/windows directory, all you need to type in the Command Prompt is "myfilename".  The STSADM commands in the file will run sequentially.

    My two cents.  It's not the only way, but it works for me.

    • Marked as answer by Peng Lei Wednesday, July 13, 2011 3:07 AM
    Wednesday, July 6, 2011 10:50 PM

All replies

  • As backup isn't a dangerous procedure and doesn't amend anything in the MOSS system, you can try as many different combinations of stsadm as you feel like (probably all except the correct one will give you parameter errors anyway).

    It's hard to imagine screen shots being necessary for what is a single command line statement.

     

    (Of course you ought also be testing restore at some stage and for that you'll need a test server ...)

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, July 6, 2011 3:39 PM
  • I'm the only SharePoint person where I work so I have to do a lot searching on the net and reading. I still think of myself as 'NEW' SharePoint Administrator and using command lines. I'm more of a Web Developer/training end users how to use SharePoint and develop web sites.

    Is this the command line I would use?

    STSADM -o backup -directory \\SharedBackupDirectory -backupmethod full

    Do I need to create a folder for the backup?

    Thanks

    Wednesday, July 6, 2011 4:30 PM
  • Same status as FMorales2!  Although there is a corporate backup process that should be backing up the SP sites and databases, I always like to run monthly backups on my own to have a quick restore path in case our farm should go down, but I set up a few BAT files in my c:/windows directory so I can use one command line code to run a script full of backup steps.  Do the following:

    1.  Create a Bin.bat file in your c:/windows directory.  Content will be:

    cd C:\program files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN (or wherever you have the STSADM file stored)

    2. Create another Bat file in the same location and use commands like this:

    stsadm -o setsitelock -url http://intranet.domain.com -lock noaccess
    stsadm -o backup -url http://intranet.domain.com/ -filename \\nas\sharepoint\restore\intranet.bak -overwrite
    stsadm -o setsitelock -url http://intranet.domain.com -lock none

    stsadm -o setsitelock -url http://intranet.domain.com/subsite-collection/ -lock noaccess
    stsadm -o backup -url http://intranet.domain.com/subsite-collection/ -filename \\nas\sharepoint\restore\intranet-subsite-collection.bak -overwrite
    stsadm -o setsitelock -url http://intranet.domain.com/subsite-collection/ -lock none

    Locking the sites prevents anyone from modifying content during the backup process.  The BAK files are copied to a backup storage solution that is maintained offsite.  This script routine makes it easy from me to backup.  Alternately, the same type of script can be used to RESTORE a site, though you probably wouldn't need to Lock the sites first.

    3. From a Command prompt, type BIN to take you to the SharePoint bin where STSADM is stored.

    4. Type the filename of the second BAT file you created with your STSADM commands.  If you have a MyFileName.bat file in c:/windows directory, all you need to type in the Command Prompt is "myfilename".  The STSADM commands in the file will run sequentially.

    My two cents.  It's not the only way, but it works for me.

    • Marked as answer by Peng Lei Wednesday, July 13, 2011 3:07 AM
    Wednesday, July 6, 2011 10:50 PM