SQL Backup Tools

SharePoint 2010, fully loaded and deployed with Office Web Application, all Service applications, Logging database, FAST Search, Content Databases, and Configuration Databases will have approximately 25 databases stored in SQL Server 2008. That is a huge number of databases to maintain and certainly a lot of content in these databases! To minimize the loss of content, it is crucial to incorporate a solid SQL database backup plan to back up all these databases.

Many options are available to back up SharePoint databases in SQL Server. In addition to Central Administration and SharePoint 2010 Management Shell, SQL Server facilitates the backup and restore of SharePoint 2010 databases with the SQL Server Management Studio, SQL ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.