question

Dez-4361 avatar image
Dez-4361 asked ·

Any Way To Restore SharePoint Query Rules

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

office-sharepoint-server-administrationoffice-sharepoint-server-search-itpro
2 comments
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This is a quick note to let you know that we are performing research on this issue.

0 Votes 0 · ·

Would you tell me whether your issue has been resolved or have any update ?
I am looking forward to your reply.

0 Votes 0 · ·

1 Answer

EchoDu-MSFT avatar image
EchoDu-MSFT answered ·

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



14.png (25.0 KiB)
1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks a bunch @EchoDu-MSFT that Table is exactly what I needed! Thnx

0 Votes 0 · ·