Do you setup SharePoint backups in the correct order?

Last updated by Brady Stroud [SSW] about 1 month ago.See history

DPM is great for backing up SharePoint data, but when you select to back up the SharePoint role of a server, DPM will only backup the SharePoint_Config database and the content databases, which is less than ideal.

To back up the SharePoint Server properly in DPM:

  1. Create a new Protection Group, for our example we will call it SharePoint Protection
  2. In the new Protection Group, add protection for the for the SharePoint role on your SharePoint server:

dpm spcorrectorder 1
Figure: Notice that SharePoint protection only selects the SharePoint_Config and Content databases

  1. Now browse to the SQL Server and add the entire SharePoint SQL Instance to the SharePoint Protection group. You will notice that you are unable to select some of the databases, as they are already being protected by SharePoint role protection.

dpm spcorrectorder 2
Figure: Ensure you back up the remaining databases in the SharePoint SQL Instance

After following these steps you will have full protection of your SharePoint databases.

Matthew Hodgkins
We open source. Powered by GitHub