Restore plan cache and buffer pool after database restore?

by Conrad S.   Last Updated October 18, 2019 21:06 PM

When restoring a database, is there a way to restore the plan cache so it doesn't have to be re-created during production use?

Similar question: is there a way to pro-actively restore the buffer cache during or after a database restore?,…. other than to create and run select statements on the tables previously in the buffer cache, a solution which would be time-consuming to create, and inevitably inaccurate.

This is a followup to this question: "Does restoring database clear buffer cache and stored proc cache"



Related Questions


Updated January 14, 2019 09:06 AM

Updated December 11, 2018 13:06 PM

Updated July 24, 2018 20:06 PM

Updated July 23, 2018 22:06 PM

Updated December 26, 2018 20:06 PM