none
SharePoint backup frequency? RRS feed

  • Question

  • Does DPM 2012 support 15 minute incremental backups of SharePoint when backing up as a SP farm or only Express Full? When creating the protection group there is only the option for Express Full. The SharePoint SQL DB recovery models are set to FULL. Would expect it to do 15 minute incremental as this is what we can do with SQL.

    Many thanks,

    Marcus

    Tuesday, August 13, 2013 5:30 PM

All replies

  • Hi,

    All Sharepoint backups are express full only.  The minimum frequency is 30 minutes for EF.  For applications, there is a maximum of 512 available recovery points. However, DPM reserves 64 recovery points, so you can only select up to 448 recovery points for applications. This is because DPM assumes that file protection could use the same volume as the applications you are protecting, so the VSS shadow copies apply to the same volume. Therefore, 448 + 64 = 512 (which is the VSS shadow copy maximum per volume).

    With an EF schedule of every 30 minutes - you can have a max. retention range of 9 days.  (448/48=9)


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, August 13, 2013 9:59 PM
    Moderator
  • Then why backup the SharePoint server through DPM?  Isn't it better to back up the SQL server so you can get the 15 minute transaction log backups?  Is this not the same as just backing up these databases?  What's the difference?
    Saturday, July 26, 2014 1:14 AM
  • Hi,

    SharePoint is not as transactional as other types of SQL workloads so you don't need frequent log backups.

    SharePoint protection allows you to perform item level recovery which is not available if you protect the SQL datases using SQL protection.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.


    Saturday, July 26, 2014 1:39 AM
    Moderator
  • Mike:

    Thanks for your answer.

    What frequency is common for SharePoint recovery points?  I agree, item level recovery is a good thing.

    Are you familiar with the VSS writer in CRM 2013?  If so, what's the advantage of using it rather than DB backup of its SQL databases?

    Saturday, July 26, 2014 3:52 AM
  • Hi,

    The backup frequency depends on your individual SLA needs - if it's a really active farm with lots of changes throughout the day, you may want to take two or more backups.  The default catalog job runs 3 hours after the express full.  In a large farm - that catalog job may take several hours to complete, so you don't want to overlap backups if possible. 


    Worst case is you added an item to the farm and lost it (meaning it was deleted) within three hours of your last express full, under that condition it would not be listed for recovery. If it was not deleted, you can always run a manual catalog to make it show up, or more likely just recovery it from the sharepoint recycle bin.

    EXAMPLE: The powershell script below sets the incremental catalog to run at 30 minutes after the express full recovery point for that farm.


    $pg = Get-protectiongroup -dpmservername (&hostname)
    $pg
    $mpg = Get-ModifiableProtectionGroup $pg[X]     (Where X is zero based number of the returned PG names listed – select the sharepoint PG)
    Set-ProtectionJobStartTime –ProtectionGroup $mpg –CatalogOffset 30 
    Set-Protectiongroup $mpg

    After this runs, future catalog jobs will be scheduled to run after 30 minutes of every express full backup.

    DPM does not natively protect CRM - therefor the writer is not used and DPM can you only protect the SQL databases.  You can see what files CRM writer is responsible for and make sure those files are included in your backups.  Run Diskshadow.exe from administrative command prompt, then "list writers" - search the output for the CRM writer and see what files are included. 


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Saturday, July 26, 2014 4:13 PM
    Moderator
  • If you have facing any problem of corrupt SharePoint database, then you can effectively repair and recover your all files from SharePoint database successfully.

    Go to:- http://www.recoverydeletedfiles.com/sharepoint-server-data-recovery.html

    Saturday, September 13, 2014 4:46 AM