SQL Server Data Manager allows organizations to:
When companies first deploy SharePoint, they often rely upon SQL Server backups to protect their SharePoint content. But when it comes to SharePoint backup and recovery, the inability to restore at the item-level makes otherwise fast recoveries burdensome and inefficient. AvePoint's DocAve SQL Server Data Manager for SharePoint is the answer, delivering full fidelity, item-level restore capabilities directly from SQL Server backups. This component complements the AvePoint DocAve Backup and Restore module, which delivers the comprehensive item-through-platform level protection for organizations running mission-critical businesses demand.
All Microsoft, All the Way
As with all AvePoint software, DocAve SQL Server Data Manager utilizes only fully supported Microsoft methodologies and APIs.
Here's a breakdown of features you'll find in AvePoint's DocAve SQL Server Data Manager, as well as those available in the DocAve Backup and Restore module.
|Features||DocAve SQL Server Data Manager||DocAve Backup and Restore|
|Restore||Item, site, and site collection level restores from SQL Server backups|
|Fast recovery of entire SharePoint platform|
|Backup||Granular backup capability(to optimize storage resources)|
|Automated backup plan creation according to content business importance|
|Protection of IIS Settings|
|Enables synchronous backup of all farm components|
|Protection of Global Assembly Cache (GAC)|
|Protection of Hive|
|Protection of front end Web Server configurations and customizations|
|Protection of any Service Applications and associated configurations|
|Protection of Fast Search configurations|
AvePoint's DocAve SQL Server Data Manager for SharePoint is the precise and powerful tool organizations need to leverage their SQL Server backups effectively and efficiently. But the next question to ask is: Is this enough?
Many organizations running SharePoint rely solely upon SQL Server's native functionality to backup and, when needed, to recover both content and the platform itself. Without a solution that enables full-fidelity, item-level restores from SQL Server backup images (something like AvePoint's DocAve SQL Server Data Manager), this can prove quite burdensome and inefficient.
But even if you do have such a tool, is this enough? Well, the answer is: It depends. Let's go step-by-step over what SQL Server backups and restores can deliver, and why even having item-level restore capabilities might or might not be all you need, given your deployment and how important it is to your organization.
When your production platform fails – due to natural disaster, corruption, or otherwise – your primary objective is to get the environment back online as fast as possible. When relying upon your SQL Server image to recover, here are some issues you will face:
As a result, recovering from a SharePoint platform failure using only a SQL Server backup makes the process very tedious, labor-intensive, and highly prone to human error.
To understand, let's take a look at SQL Server backups from another perspective…namely, its impact on your storage and system resources. For this analysis, let's focus on the capabilities of SQL Server backups during the actual backup process.
Now that we have an understanding of the capabilities and drawbacks of SQL Server backups for SharePoint data protection, let's list out some key questions every administrator should ask themselves when deciding if SQL Server images are a potent enough strategy for their organization:
Every organization will have a different set of answers to these questions. And every organization must come to its own conclusion as to whether a more potent and powerful SharePoint data protection strategy is needed. Some might decide that their SharePoint SLAs allow for the time and energy required to restore their production platform manually. Some might feel that their storage and system resources allow them the ability to take SQL Server backups as often as their most critical data requires, and store it without worry or constraint.
For these organizations, there is a cost-effective and powerful solution that will meet your needs. Learn more about how to deliver comprehensive and optimized platform protection with DocAve Backup and Restore.
Not fully migrated to SharePoint 2013 or 2010 yet?
Read about how one of New Zealand's leading research organizations reduced SharePoint item-level recovery from one hour to 5 minutes with DocAve.
This case study highlights how this organization slashed data restore time from hours to minutes.
Learn about how this company can now restore individual documents in as little as one minute.
This white paper offers planning practices, guidelines, and implementation considerations for SharePoint data protection and disaster recovery, and provides proven strategies for executing these practices in accordance with your organizational needs.
Still on a prior release of SharePoint?
AVEPOINT IS THE ESTABLISHED LEADER IN ENTERPRISE-CLASS BIG DATA MANAGEMENT, GOVERNANCE, AND COMPLIANCE SOFTWARE SOLUTIONS FOR NEXT-GENERATION SOCIAL COLLABORATION PLATFORMS. FOUNDED IN 2001 AND HEADQUARTERED IN JERSEY CITY, NJ, AVEPOINT SERVES MORE THAN 13,000 ORGANIZATIONS WORLDWIDE, WITH FOCUSED PRACTICES IN THE ENERGY AND UTILITIES; FINANCIAL SERVICES; HEALTHCARE AND PHARMACEUTICALS; AND PUBLIC SECTOR INDUSTRIES.