Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm working on creating a SharePoint 2010 Enterprise Server disaster recovery (and backup-restore) policy for our organization. From what I've read, there are several options for doing backup-restore:

  • Central Administration backup and restore
  • PowerShell backup and restore
  • Recycle Bin restore
  • SQL Server db backup + restore

We're thinking of creating a PowerShell script that can run hourly to do differential backups and daily full backups of SharePoint. Is this a good approach? Are there scripts to do this? Thank you :)

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

You can configure Schedule Task, which is feature in Windows Server 2008 and then execute this PowerShell code: http://gallery.technet.microsoft.com/scriptcenter/9b99c435-8831-4c9e-a70b-1f13158ef22a

Or http://social.technet.microsoft.com/wiki/contents/articles/how-to-sql-server-databases-backup-with-powershell.aspx

You must document your Disaster Recovery plan carefully and you will then need to list all of components. Remember that your backup/restore plan is just a part of Disaster Recovery.

This article provides an overview of 10 step to do DR.

You can also learn the reference that is mentioned by Chakkaradeep Chandran.

share|improve this answer
add comment

Creating a DR plan for SharePoint depends a lot on the business needs. I would first start off with defining what my RPO and RTO are. Based on that, next is to design it.

A very basic plan that many follow is SQL Mirroring with Log Shipping. To optimise the performance, the backups can be performed from the mirrored sql server.

Dpending on your business needs, you can stand up a warm or hot stand-by farm.

Make sure you read this guide - Business continuity management for Microsoft SharePoint Server 2010 which provides in-depth information about back and recovery plans with PowerShell scripts.

Hope that helps.

Cheers, Chaks

share|improve this answer
    
Thanks, Chakkaradeep. I'm going to ask a silly question: What are RPO and RTO? –  Alex C Sep 15 '11 at 11:12
1  
RPO is Recovery Point Objective which covers how much data loss is acceptable. If you are doing daily backups then that would be up to 24 hours of data loss. RTO is Recovery Time Objective and that covers how long it should take to get the system back to the running state. –  Mike Oryszak Sep 15 '11 at 15:11
1  
And I agree with Chaks, the BUSINESS planning part is the most important part and what helps guide all of the other technical decisions. –  Mike Oryszak Sep 15 '11 at 15:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.