How should I backup my 2010 SharePoint server? As I see it there are 3 choices:
- Full Farm backup
- Site collection backup
- SQL Server backup
We're only doing backups using points 1 (occasionally) and 2 (nightly, using a PowerShell script).
I get the feeling (but can't find evidence to confirm it) that by just using SharePoint you do not backup all the information you need?
If I was to also backup SharePoint data using option 3 SQL Server what would I need to backup?
At present there are 22 databases in the SQL data directory, do I need to backup all of them?