SharePoint Backup for low-RPO environments
I have a SharePoint environment where we need a low RPO (3H minimum), and I am strugling a bit with the "right" solution, and since I don´t have any SharePoint experts handy and the SharePoint documentation is so "sparse", I am hoping someone here can assist.
I have tried using incremental SharePoint backups, but they are approx 80% the size of a full backup (which I guess is per design, since the documentation states that Content-DB does not support incremental backups).
Important stuff is going into this customers SharePoint, so we need data out every 3 hours (as a minimum!), and since the incremental backup run for approx 3 hours, its basically doing backups 24x7 with this kind of solution (and thats not even utilizing GRT :-) ).
I have the following suggestions and currently I am leaning towards option 1, but perhaps someone could share some experience/input here?
- Drop SharePoint Agent and switch to SQL Agent backups (transaction log backups) and find a SharePoint expert to point out what else is needed to backup to ensure a consistent recovery (and test it :-) ).
Question is if I can combine this with GRT backups as well (or will they "screw up the transaction log order" or SQL full backups...
- Combine SharePoint Agent daily fulls with 3-hourly SQL Agent transaction log backups (which according to TECH159231 is possible).
But the SharePoint agent appears to automatically recover the database as part of the D/R restore (have not tried it yet), so I guess i will have nothing to use the transaction logs for, since I cannot apply the logs after the DB is opened.
- Sit down and wait for 7.6.0.? which will support VMware SharePoint incremental backups :-)