Forum Discussion

A_J_A's avatar
A_J_A
Level 3
9 years ago

Sharepoint backup - do I need separate database backup job?

I am looking at the directions below and am not clear. Do I need to have a regular SQL Server backup job (Using the database extension tool) scheduled in addition to the SharePoint farm backup? Ar...
7.6
Backup and Recovery
Basics
Best Practice
NetBackup
Windows Server (2003-2008)
  • GulzarShaikhAUS's avatar
    GulzarShaikhAUS
    9 years ago

    Many of Sharepoint admin prefers SQL databases for the restore in comparision with the Netbackup Sharepoint based restores. Sharepoint keep ALL information in SQL DB so it is very easy for them to restore. I would advise you to include the SQL database backup in you B/R plan for SP recovery.

    Have your backups configured in such a way to facilitate complete DR. See the attached for all policies which are needed to be created. 

    Please bare in mind that GRT backups for Sharepoint are extreamly slow and you cannot have them backed up using INCR/Diff backups. It always needs to be FULL.

     

  • watsons's avatar
    watsons
    9 years ago

    For Sharepoint only, a farm + a GRT-level backup policies would be good enough.

    It also depends if the backend SQL server has other non-Sharepoint DBs hosted. If it does, you need to have SQL policy to back those (non-SP DBs) up.

    Whichever way you choose, it is recommended not to mix them up - meaning if Sharepoint DB is setup to backup by SP policy, then don't use another SQL policy to backup the same DB. This will mess up the schedule and may cause failure due to inconsistency.

    And if you only use SQL policy to backup everything (including SP DBs), but when it comes to GRT-level restore I am not sure how you can get it done via SQL restore.

watsons's avatar
watsons
Level 6
9 years ago

For Sharepoint only, a farm + a GRT-level backup policies would be good enough.

It also depends if the backend SQL server has other non-Sharepoint DBs hosted. If it does, you need to have SQL policy to back those (non-SP DBs) up.

Whichever way you choose, it is recommended not to mix them up - meaning if Sharepoint DB is setup to backup by SP policy, then don't use another SQL policy to backup the same DB. This will mess up the schedule and may cause failure due to inconsistency.

And if you only use SQL policy to backup everything (including SP DBs), but when it comes to GRT-level restore I am not sure how you can get it done via SQL restore.