SharePoint 2010 Backup and Restore

Posted on 2014-03-18
Medium Priority
Last Modified: 2014-03-20
I have the following portal setup,


For those portal, many sites are created, eg http://portal/sites/xxxx

How to use a powershell or stsadm to ensure all these sites and portal are backup ?

Question by:AXISHK
  • 5
  • 4

Expert Comment

ID: 39936998
You can perform a Farm Backup with PowerShell. First some things have to be in place in order to create a succesfull farm backup.

1.Your Central Admin app pool account must have read/write access to the location of the backups.
2.Your SQL Service account must have read/write access to the location of the backups.
3.If you're running a farm backup from STSADM or Windows PowerShell, the account you're running it as must have read/write access to the location of the backups
4.The location must be accessible from the SharePoint machine the backup is running on.
5.The location must be accessible from the SQL instance that SharePoint is trying to back up.
6.This is why all the examples are UNCs, \\server\share, and not local paths, C:\backups

Then you can backup with PowerShell. for Example;

Backup-SPFarm -Directory E:\Backup -BackupMethod full

Some information;


Author Comment

ID: 39938653

I have surfed the restore of Sharepoint :
Restore-SPFarm -Directory C:\Backup -BackupId 12345678-90ab-cdef-1234-567890abcdef  -RestoreMethod overwrite -RestoreThreads 10 -Force

But, how to get the BackupId ??

I have a sharepoint frontend and SQL database backend. For disaster plan should be

1. Use Window backup to backup the frontend server.
2. Use your script above to fully backup the SharePoint data
3. To rebuild the system, use Window restore to rebuild the SharePoint Frontend.
4. Use the Sharepoint script to restore the data.

SQL database shouldn't be a concern. Once I rebuild the SQL server, the sharepoint data will be rebuild using the SharePoint restore script, correct ?

In addition, how can I use the sharepoint backup to restore a particular site, say, "http://portal:8080" or "http://portal/sites/xxx" ?


Expert Comment

ID: 39939143
The backups taken by PowerShell can be restored by Central Administration. Also it is possible to restore the farm using the PowerShell Script. To restore a farm from backup you can use Restore-SPFarm commandlet.

To obtain a list of all the backups available, with the backup ID, use:

Get-SPBackupHistory -Directory <Backup folder> -ShowBackup [-Verbose]

The output will be similar to this;

Backup ID
To backup a Site Collection, use the PowerShell script below;

Backup-SPSite -Identity <Site collection name> -Path <backup file> [-Force] [-NoSiteLock] [-UseSqlSnapshot] [-Verbose]

Backing up your SQL server is very important. After a restore of the server, the databases can be attached to the SharePoint server again.

It's very important that you test the restore procedures in different scenario's!!!
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 39939721
I suppose "Backup-SPFarm" can restore everything once I install a new SharePoint server, with a new SQL Server. Why do I still need to backup the SQL server ?

Can I say SQL Server is important when frontend Sharepoint is still live but SQL Server need to rebuild ? Under this stituation, only SQL restore is needed, correct ?

Expert Comment

ID: 39941723
It doesn't really matter how, but you have to be sure that you have proper backups of your databases. And again test the restore procedure of the databases in different scenarios.

Author Comment

ID: 39941810
Agree. Just want to confirm one thing.

Does  "Backup-SPFarm" backup sharepoint configuration and content database stored in SQL Server ? Or what else will not be handled by SharePoint backup ?


Accepted Solution

SvenIA earned 2000 total points
ID: 39941814

Author Comment

ID: 39942549

Author Closing Comment

ID: 39944302

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question