Is this a good SharePoint SQL Backup and Maintenance Plan Strategy?
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 AMSQL Backups failing on SharePoint Search_Service_Application_AnalyticsReportingStore
Hi all I'm getting an error in the event logs saying the differential backup failed but no database listed. From what I can tell its the SharePoint Search_Service_Application_AnalyticsReportingStore. All other differential databases work. We get the same error when the full backup maintenance plan runs on that database. There are no logs that report an error in the SQL logs. In actual fact it doesn't even show a log suggesting this database was attempted to be backed up. Anyone know if this database is critical to backup or if there is any specific processes one needs to put in place to back it up or why this might be happening? Application Log: EventID 12291 -Package "Differential Backup" failed. EventID 208 -SQL Server Scheduled Job 'Differential Backup.Subplan_1' (0x9BD7CA5D8C9A9149BF92FA05EFC0CBE7) - Status: Failed - Invoked on: 2021-04-19 01:00:00 - Message: The job failed. The Job was invoked by Schedule 14 (Differential Backup.Subplan_1). The last step to run was step 1 (Subplan_1).