Any Way To Restore SharePoint Query Rules

Question

Any Way To Restore SharePoint Query Rules

Msdc 271

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

Echo Du_MSFT 17,341 Reputation points

2020-07-30T11:49:06.673+00:00

This is a quick note to let you know that we are performing research on this issue.
Echo Du_MSFT 17,341 Reputation points

2020-08-06T11:05:49.857+00:00

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

Answer accepted by question author

0 additional answers

Your answer

Echo Du_MSFT 17,341 Reputation points

2020-07-30T11:49:06.673+00:00

This is a quick note to let you know that we are performing research on this issue.
Echo Du_MSFT 17,341 Reputation points

2020-08-06T11:05:49.857+00:00

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

Answer 1

Echo Du_MSFT 17,341

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:

Msdc 271 Reputation points

2020-08-19T18:22:52.43+00:00

Thanks a bunch @Echo Du_MSFT that Table is exactly what I needed! Thnx

Share via

Any Way To Restore SharePoint Query Rules

0 additional answers

Your answer