SharePoint 2016 backup issue

Hanamichi Sakuragi 246 Reputation points
2020-08-19T07:31:34.943+00:00

Hi,

I scheduled a Farm backup Shared Services using Differential on our SharePoint 2016 farm.

After it competes the run and checked the logs I see this 15 warnings.

I run the full Farm Backup Shared Services last night without any issue.

Can somebody help me on this issue?

[8/19/2020 6:20:46 AM] [Verbose] [SP_AppService_Search_AnalyticsReportingStore] SQL Server Connection String: Data Source=DBSERVER;Initial Catalog=SP_AppService_Search_AnalyticsReportingStore;Integrated Security=True;Enlist=False;Pooling=True;Min Pool Size=0;Max Pool Size=100;Connect Timeout=60;Packet Size=8000;Application Name=SharePoint[powershell][1][SP_AppService_Search_AnalyticsReportingStore].
[8/19/2020 6:20:46 AM] [Warning] [SP_AppService_Search_AnalyticsReportingStore] The previous full SQL backup for the database SP_AppService_Search_AnalyticsReportingStore was performed by another backup tool and may not be restored correctly.
[8/19/2020 6:20:46 AM] [Verbose] [SP_AppService_Search] SQL Server Message: Processed 6 pages for database 'SP_AppService_Search', file 'SP_AppService_Search_log' on file 1.
[8/19/2020 6:20:46 AM] [Verbose] [SP_AppService_Search] Backup file size changed to 4.23 MB.
[8/19/2020 6:20:46 AM] [Verbose] [SP_AppService_Search] SQL Server Message: BACKUP DATABASE WITH DIFFERENTIAL successfully processed 406 pages in 0.255 seconds (12.438 MB/sec).
[8/19/2020 6:20:46 AM] [Verbose] [SP_AppService_Search] SQL command completed at: 8/19/2020 6:20:46 AM.
[8/19/2020 6:20:46 AM] [Verbose] [SP_AppService_Search] SQL Server Command:

Thank you.

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,955 questions
{count} votes

Accepted answer
  1. Trevor Seward 11,706 Reputation points
    2020-08-19T14:12:14.787+00:00

    This means a different SQL backup was run for that database. If you're certain that there are no other SQL backups running, you can take a manual full backup of that database via SQL Server Management Studio which should eliminate that error the next time you run your farm backup.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Hanamichi Sakuragi 246 Reputation points
    2020-08-20T05:38:25.187+00:00

    Thanks Trevor,

    I will do it and update you on this.

    0 comments No comments

  2. Emily Du-MSFT 47,216 Reputation points Microsoft Vendor
    2020-08-20T06:16:09.977+00:00

    Agree with Trevor.

    Here’s a similar question for you to refer to:

    The previous full sql backup for the database may not be restored correctly


    If the response is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.