DocAve Version 5 for SharePoint 2010

Up until recently I've been running my backups using the built in backup and recover tool and Powershell (see http://imperfectit.blogspot.com/2010/03/automate-sharepoint-2010-farm-backups.html), but my environment has started to grow and become more complex. That, and it's larger than the recommended 150 GB limit "suggested" by Microsoft. As a result I had to find a more robust data protection solution. After much testing I went with AvePoint's DocAve v5.

DocAve Backup and Recovery for SharePoint 2010 offers two types of backup and recovery: Granular and Platform


Granular Content and Data Protection

• Supports SharePoint 2010, Microsoft Office SharePoint Server (MOSS) 2007 and Windows SharePoint Services 3.0 environments (via DocAve v5), and SharePoint Portal Server 2003 and Windows SharePoint Services 2.0 (via DocAve 4.5). Support for SharePoint 2001 is available – please contact an AvePoint representative).

• Full fidelity backup and restore of all lists, libraries and items (including Events, Links, Tasks, Contacts, Announcements, Discussion Boards, Surveys, Issues, Custom Lists, Areas, Sub Areas, Portal Links, Workflow Definitions, Layout Templates, and Site Definitions, along with access permissions, metadata and version histories)

• Backs up and restores SharePoint workflow definitions

• Full fidelity item-level restore from DocAve, SQL native backups created by T-SQL script or a maintenance plan, DPM, IBM-TSM, HP Data Protector, as well as third-party embedded SQL backup engines, including HyperBac and LiteSpeed Engine

• Granular, item-level restore with sliding timeline view, along with full text keyword search and identification criteria mask search

• Restore content to different SharePoint instances or locations, including file systems and networked file shares with DocAve's "out-of-place restore" functionality

• Manual and Automated Data Pruning feature helps manage historic SharePoint backup data and improve access speed to more recent backups

• Data Coalescing feature allows collapsing incremental backups into one backup data set for easy retrieval.

• Item-level "out-of-place restore" for complete hardware failure

• Fast granular backup speeds, up to 60GB/hour

Comprehensive Platform Protection

• Backup and recover entire SharePoint farms or selective components including all servers and back-end SQL databases with all configurations, Index/Job servers, as well as front-end IIS settings and file system resources

• Quickly and selectively restore individual or a combination of farm components (content databases, web applications, SSP, etc.)

• Safeguard front-end web server resources (IIS settings, Template files, user selected resources, local file systems, etc.)

• Backup InfoPath form templates, Project Server content and Site Definitions

• Support for SharePoint Features

• Up-to-the-minute restore using SQL logs restoration

• Leverages Volume Shadow Copy Service (VSS) to ensure consistent point-in-time backups

• Fast platform backup speeds, up to 100 GB/hour

• Efficient data streaming via open standards, including VDI and VSS without staging location requirements

If you've worked with this product or others, I'd be interested to hear your opinions.

Thanks!

SharePoint 2010 Granular Backup and Restore - Recovering Data from an Unattached Content Database

he built-in backup tool in SharePoint 2010 accommodates backing up the following:

• Back up a farm
• Back up a farm configuration
• Copy configuration settings from one farm to another
• Back up a Web application
• Back up a service application
• Back up search
• Back up the Secure Store service
• Back up a content database
• Back up databases to snapshots
• Back up customizations
• Back up a site collection
• Export a site, list, or document library
• Back up or archive logs

See here for more detail: http://technet.microsoft.com/en-us/library/ee428315.aspx

Sounds pretty good right? What if you have a user who deleted a list, library or even an individual document? If it's not sitting in the recycle bin for the site collection, then what?

The answer is a new feature called granular restore which gives you one more option to use before you have to go to an expensive third party backup and restore solution. The only catch is that you have to have a SQL backup of the content database in question that you can mount in SQL using SQL Management Studio. To be safe, I use the built-in SharePoint 2010 backup tool to run farm backups (How to Automate SharePoint 2010 Farm Backups), but I also do regular SQL backups. In the event of some type of disaster, I've given myself a few options for doing a restore.

Step 1

In SQL highlight the content database you want to restore, right-click it and select Tasks - Restore -Database. In the "To Database" field, type a name for the new database (ex: DatabaseName_restore). Specify the point in time you want to do the restore from.

Step 2

Go into Central Admin on the SharePoint server and select Backup and Restore - Recover data from an unattached content database. Specify the SQL server and database name you created above during the restore. Select Browse Content and hit next.

Step 3

Select the site collection, site, and list or library you want to restore. Specify that you want to export the selected content, and specify a location for the file. I find the best way to locate the library, list, etc that I want to restore is to use the Search field that's presented to you.

When you hit Next, you'll be prompted for the location you want to export the site to. I just use a local folder. Next, hit Start Export.

Step 4

Now that you exported the data from the restored database, you can import the data into the production site to restore the missing list, library, document, etc.

Open SharePoint PowerShell while logged in as Farm Admin and run the Import-SPWeb command to specify the identity of the web you're working with, and the path to the restore file you created above:

Note that you specify the root web, and it will restore the data you specified when you browsed the restored database to its original location. To learn more about what options are available when importing data visit http://technet.microsoft.com/en-us/library/ff607613.aspx.