Sep 10 2024 12:40 AM - edited Sep 10 2024 12:48 AM
I have a test environment witch contains two farms:
2 Sharepoint Server 2019 Enterprise (Custom Role) + 2 SQL Server 2019, Both farms are located in the same domain. The URLs of the sp.domain.local and spdr.domain.local farms correspondingly. Firewall is disabled on all VMs.
I tried to restore SSA from the SP farm to the SPDR farm, using standard Sharepoint backup tools (via the Center Administration ). For some unknown reason, after the recovery process is completed, the SSA stuck in the status "Paused for:Backup/Restore". At the same time, the backup and recovery processes themselves are completed without errors and warnings. ULS are clean. From PowerShell, the Search Service Application itself is in the 'Online' status, all search components are in the 'Active' status. At the same time, any actions with the SSA add to its 'External request' status and it remains in this form until it is deleted. If you try to make an Index Reset, then the same status is also displayed for a while in the 'Administrative Status' field, while the index itself remains in place.
Over the past week, I've tried all the instructions I could find on the Internet:
$SSA.ForceResume($SSA.IsPaused())
#---
$SSA.Pause() | $SSA.Resume()
#---
Resume-SPEnterpriseSearchServiceApplication $ssa
#---
Foreach ($cs in ContentSources){$cs.ResumeCrawl()}
I tried Stop the Timer Service and cleaned the cache
According to this article I tried to change the value 130 to 0 in the search database, in the 'MSSStatusChange' table. In this case, SSA switched to the 'Running' status, but Index Reset and Full Crawl were started, but never completed (I waited almost a day).
When I created a new SSA, it accepted the status of 'Running', Search works as expected.
I'm not sure if CU July 2024 is to blame for the problem, but on test farms without this patch, the search service is being restored normally.
Any ideas, how I can restore SSA from backup?