SQL Backups failing on SharePoint Search_Service_Application_AnalyticsReportingStore

Copper Contributor

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).

 

1 Reply
Have you tried changing the owner of the job to SA, if not try changing to SA.

For more detail on EventID 208 you can refer the below link.
https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-208-database-en...