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:\Users\pinal\Documents\Visual Studio 2017\Backup Files\Solution1

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 (https://blog.sqlauthority.com)

Quest

SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS
Previous Post
Email an Execution Plan – SQL in Sixty Seconds #114
Next Post
Full-Screen Execution Plan – SQL in Sixty Seconds #117

Related Posts

Leave a Reply