Recover Crashed Query in SSMS – SQL in Sixty Seconds #116

Recover Crashed Query in SSMS - SQL in Sixty Seconds #116 116-Recover-main-coveryt-800x450

Has it ever happened to you when you are working on a large SQL Server query and suddenly your SQL Server Management Studio (SSMS) crashes? Honestly, it has happened to me quite many times and it is indeed frustrating. Today we will learn about how we can recover crashed queries in SSMS.

The good thing is that when SSMS crashes at that time, it automatically saves all the work due to configuration settings in the SSMS. You can access that configuration by going to Tools >> Options >> Environment >> AutoRecover.

Here is the screenshot for the same.

Recover Crashed Query in SSMS - SQL in Sixty Seconds #116 recoversettings

Now due to any reason, if the file is not recovered after the SSMS has crashed, one should not worry at all. SSMS saves your file for a few days in a special folder. In my case the name of the folder is as following:

C:UserspinalDocumentsVisual Studio 2017Backup FilesSolution1

Now the name of the folder may vary based on the version of SSMS and Visual Studio installed in your machine. I have included all this in this SQL in the Sixty Seconds video over here:

Go through the video and do let me know what is your feedback. I have been doing many videos recently and if you like them, you can subscribe to my channel here.

Reference: Pinal Dave (

Author: admin

Leave a Reply

Your email address will not be published.