Is this a good SharePoint SQL Backup and Maintenance Plan Strategy?

[Gerry_Morley]

Hi all

Looking for some guidance. Setting up SharePoint SQL Backups for the first time and maintenance plans. Is this a good strategy in general even if there is no company policy yet defined?

Environment has 2 SQLs VMs on a Microsoft Failover Cluster hosted split over 2 ESXi hosts connected to a SAN. (Cluster Shared Volume in use for SQL Data, SQl Log and SQL Backup volume).

General DB Maintenance Task Check Database Integrity (All databases include indexes) Rebuild indexes (All databases, tables, views, orig amount of free space) Update Statistics Task (Full scan all DB and tables and views, existing statistics) History Clean Up Task (Backup Job and Maintenance plan. Age older than 4 weeks) Maintenance Cleanup of Reports (Age older than 4 weeks)	12:01AM Sunday
Full Backup  - (compress, backup set expires after 14 days). Databases (All)	Weekly - 1AM Sunday
Differential Backup  - (compress, backup set expires after 7 days) Databases (All except Master and Tempdb)	Daily - 2AM excl Sunday
Transaction Backup  - (compress, backup set expires after 1 day) Databases (Content, SharePoint_Config and SharePoint_AdminContent)	Daily - Every 15 Minutes
Full Backup cleanup	Weekly - 2:30AM Sunday
Diff Backup cleanup	Weekly - 3AM Sunday
Log backup cleanup	Daily - 4 AM

[#2]

You can add another step to take daily full backup of system databases.

And why to use backup set expiry. If you wanted to clean the files you can delete it via job on certain intervals.

Rest looks fine.