Sharepoint backup - do I need separate database backup job?
- 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.
- 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.