locked
SharePoint Backups RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello all, 

    I am looking for some information on SharePoint backup.  I still don't know a lot of the beast called SharePoint except for a very particular set of permissions administration and upkeep.  I wanted to know exactly what is getting backed up when I perform a SharePoint Farm backup in CA versus a full SQL backup on the SQL Server.  Are these 2 methods getting different information, or can I just use one method or the other?   I can't seem to find the answer to this question on other sites so I figured that I would start here.   This is not just to have a good set of backups, but mostly in preparation to upgrade to 2016, single server farm.

    Also, what are some of the products that you use to backup the SharePoint farm and its data?  Is it SQL tools, Central Admin backup using a script in a scheduled task, or are you using a 3rd party software solution?  

    Thanks in advance!!

    David Hood

    Monday, September 24, 2018 3:24 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    A full farm backup also backs up the databases on SQL. What I would suggest:

    Continue using SQL to backup all databases sans Config, Admin, USPA Sync, and Usage. These databases either cannot be restored or have no value to be restored.

    From the SharePoint side, perform a configuration only backup.

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    • Marked as answer by DHood82 Tuesday, September 25, 2018 1:17 PM
    Monday, September 24, 2018 3:31 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    A full farm backup also backs up the databases on SQL. What I would suggest:

    Continue using SQL to backup all databases sans Config, Admin, USPA Sync, and Usage. These databases either cannot be restored or have no value to be restored.

    From the SharePoint side, perform a configuration only backup.

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    • Marked as answer by DHood82 Tuesday, September 25, 2018 1:17 PM
    Monday, September 24, 2018 3:31 PM
  • Question
    Sign in to vote
    1
    Sign in to vote


    https://www.softwebsolutions.com/resources/migrating-sharepoint-from-2010-to-2016.html 

    Priti Arya

    Monday, September 24, 2018 3:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    So, really a 3rd party backup software that works with SharePoint is kind of a waste of money since I have such a small implementation?  Unless I want granular file\item level restores??

    David Hood

    Monday, September 24, 2018 6:13 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I would say it probably is. I've never had the need to use one, even in multi-TB installations. You can even use unattached CDB restore option to get more granular than the database level.

    https://docs.microsoft.com/en-us/sharepoint/administration/restore-content-from-an-unattached-content-database

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Monday, September 24, 2018 6:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    If you think the suggestion provided by Trevor Seward is helpful, you could mark it as an answer. It will help others who meet the similar question in this forum.

    Best regards,

    Allen Bai

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.


    Tuesday, September 25, 2018 7:14 AM