Currently we have a series of scheduled granular backups for the site collection level that use the PS "Backup-SPSite" command (e.g. https://myportal.com). I test these backups frequently, and have found them to work fairly well when restoring to a SP server that is already fully configured the same as the original SP server that was backed up from.
I am wondering if we should also be performing a scheduled backup of the content database specifically via SQL, and if we should, why we would want to consider doing so?
I would also be curious to know how this is different from a granular backup on the site collection level?
Lastly, are there any other backup options that I failing to consider? Our SP site collection is under 10gb and is relatively simple (one physical server, one farm, everything in one spot).
I did take a read over the Microsoft SharePoint Foundation 2010 Backup & Recovery overview document, but I found it to bring up more questions than it answered: