Any Way To Restore SharePoint Query Rules

Msdc 271 Reputation points
2020-07-30T04:36:06.8+00:00

Hey There,

So i had to totally remove my SharePoint search service application which I didn't realize would totally wipe out all my SharePoint Query Rules (Promoted Results). I had over 50-70 different rules in place and was wondering if I could possibly restore a old DB and somehow just view the data. I do not want to import at all, just view and create them back into the environment. Thnx

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,340 questions
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,941 questions
Accepted answer
  1. Echo Du_MSFT 17,161 Reputation points
    2020-07-31T02:55:43.533+00:00

    SharePoint Query Rules were stored in the “dbo.MSSQueryRules” table under the Search Service Application DB that you named, you could check whether this table has the valuable data that you needed in it.

    For example:

    14678-14.png

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.