SharePoint 2010 Backup and Restore

I have the following portal setup,

http://portal:8083                   
http://portal                             
http://portal:8088                   

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 ?

Tks
AXISHKAsked:
Who is Participating?
 
SvenIACommented:
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;

http://blogs.technet.com/b/heyscriptingguy/archive/2011/06/22/use-powershell-to-back-up-your-sharepoint-farm.aspx
0
 
AXISHKAuthor Commented:
Tks.

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" ?

Tks
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
SvenIACommented:
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!!!
0
 
AXISHKAuthor Commented:
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 ?
0
 
SvenIACommented:
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.
0
 
AXISHKAuthor Commented:
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 ?

Tks
0
 
AXISHKAuthor Commented:
Tks
0
 
AXISHKAuthor Commented:
Tks
0
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.

All Courses

From novice to tech pro — start learning today.