SQL SERVER – Save Auto Recover Information – SSMS

Though, I have many complaints about SQL Server Management Studio (SSMS) (read the latest one here), I also like some of the features for sure. In this blog post, we will take about Auto Recover feature of SQL Server Management Studio.

This is one of the most important settings but I do not see much of the awareness for this feature, hence, I decided to write a blog post about it. This feature is actually not a part of SQL Server but rather a part of the SSMS. If you are using any other IDE to talk to SQL Server, you may not have this feature available to you.

In SSMS go to Tools >> Options >> Environment >> Auto Recover. Over here you can see the following screen.

SQL SERVER - Save Auto Recover Information - SSMS autosave-800x466

Whenever I go for any consulting most of the time, the first thing I check the values of this setting and often change Save Auto Recover information every setting from 5 to 1 minutes so I can minimize my loss in case of SSMS crash. I believe everyone should commonly practice this as if you are a DBA or Developer and working at best of your efficiency, you do not want to even loss single minutes of your work, sometimes we do lots of coding in just five minutes.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Server, SQL Server Management Studio, SSMS
Previous Post
Next Post
SQL SERVER – Alternate Rows Color in Table Background in HTML

Related Posts

2 Comments. Leave new

  • How to recover this data? I have been working on a Db diagram and SSMS keeps crashing and i lose everything I have done.

  • I wouldn’t use that ‘feature’ if your My Documents is on a network drive or at worst some cloud drive with shodding connectivity. MS should let you choose where the auto-recover is stored, otherwise you are better off turning that off or using older stable SSMS versions and not beta-test new versions that randomly crash.


Leave a Reply