O'Reilly logo

Microsoft SharePoint 2013 Disaster Recovery Guide by Joel Plaut, Jeff Gellman, Pat Esposito, Peter Abreu, Pavlo Andrushkiw, Peter Ward

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Non-SharePoint database backup and restore

For many developers, it is very appealing to add their solutions to custom databases hosted on the farm database server, as it seems a logical solution because the application or integration process is part of SharePoint. SQL Server backups are the most reliable product.

The authors recommend using a SQL Server maintenance plan schedule for full backups, or if the organization uses an enterprise schedule system, use PowerShell. See the following samples:

Backing up DB with SQL Server Management Studio

To perform a backup with SQL Server Management Studio, perform the following steps:

  1. Open SQL Server Management Studio and connect to the SQL Server database instance hosting the SharePoint database that is required ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required