SSMS AutoRecover Location

By default, SSMS saves your queries every 5 minutes and keeps the info for 7 days.
 
I suspect this has saved many a DBA when unforeseen outages occur.
image1image2
One quick way to get to this recovery location is shown below and is by right clicking on a Query tab:
image3image4
As you may have noticed, this provides a quick access method to your hidden AppData folder.

Leave a Reply