Agent-based backups for Windows and Linux, centralized agent management
Post Reply
pcts
Service Provider
Posts: 8
Liked: 3 times
Joined: Nov 15, 2017 6:16 pm
Contact:

Advice needed on using Veeam to backup SharePoint Cluster and its SQL DB Cluster?

Post by pcts »

Taking on support for a new customer that has had a recent SharePoint 2019 install hosted on ESXi.

The guy who originally setup SharePoint setup a full SQL backup to happen each night but the log files had ballooned (esp sharepoint config and main database) as there were no transaction log backups scheduled. He then left.Onsite IT have just put in place Veeam to backup the 6 SharePoint servers (2 x app, 2 x web, 2 SQL) but it looks like there is no application aware backups going on, no truncating of logs files etc. Anyone here using Veeam soley to backup their on premise SharePoint VMS and SQL Cluster and can share how you are backing it up with Veeam?

The SQL servers have Veeam agents installed (I assume since Backup of Cluster Shared Volumes are not supported by Veeam and as the SQL VMs are in a Microsoft failover cluster and utilise bus sharing and share the same SQL DATA,SQL LOG and SQL Backup VMDK files.) Note: There is a separate cluster shared volume for SQL Data, SQL Log, SQL Backup on the SAN.

I am considering at a high level maybe the following might be a good idea but wanted to get your thoughts:
(i) kill the daily SQL full backup plan and move to Veeam full as the complete backup solution for all the SQL Databases (Content, Config, Master etc....)?
(ii) configure daily Veeam incremental backups of App servers, Web Server and SQL OS with maybe full backups monthly and keep clean down incrementals each month.
(iii) weekly Veeam SQL full backup of all SQL Databases, keep for two months?
(iv) daily transaction log backups for SQL DB (or would one do this more frequently), keep for one month?

or would you recommend let SQL Backup and Maintenance plans manage the SQL DB Backups and set Veeam to do everything else?

I assume if Veeam agent is installed on the SQL Veeam can backup the files stored in the SQL Data, SQL Log and SQL Backup CSV as it has direct access to the data in the volumes just can't backup the overall volume itself.

HannesK
Veeam Software
Posts: 7807
Liked: 1348 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Advice needed on using Veeam to backup SharePoint Cluster and its SQL DB Cluster?

Post by HannesK »

Hello,
if we back up the SQL cluster today, then they have a normal shared volume (not a cluster shared volumes aka CSVs).

i: I'm not sure what it is about. every incremental backup Veeam does is a logical full
ii: daily incremental sounds good. not sure what you mean with "clean down incrementals". Retention will be applied according to the configuration
iii: you already have that when you configure ii with weekly & monthly restore points
iv: every 480min is the maximum possible for log backups.

I would do everything with Veeam, except you found something that is impossible.

Best regards,
Hannes

PS: I deleted the other post as it was a duplicate.

pcts
Service Provider
Posts: 8
Liked: 3 times
Joined: Nov 15, 2017 6:16 pm
Contact:

Re: Advice needed on using Veeam to backup SharePoint Cluster and its SQL DB Cluster?

Post by pcts »

Thanks HannesK

When you say "except you found something that is impossible." - can you expand on that?

Regards
PCTS

HannesK
Veeam Software
Posts: 7807
Liked: 1348 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Advice needed on using Veeam to backup SharePoint Cluster and its SQL DB Cluster?

Post by HannesK »

Hello,
that means if you really have a CSV. I just believe that you have a normal shared volume because it sounds like SQL backup is working fine today with the agent.

If you really have a CSV, then there are other options like
- migrate to shared volume
- use SQL native tools and only back up the dumps

Best regards,
Hannes

PS: sorry if my guess is wrong, but I have seen many customers not knowing the difference between shared volume and CSV

Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests