Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I tried to go to Tools > Environment > AutoRecover.

  • The check box of save autorecover is checked.
  • Save every "5" minutes.
  • Keep autorecover info for: 7 days.

But it doesn't save any auto recover files (I searched inside my user folder for *.sql), and doesn't suggest to auto recover when the Management Studio closes by a power down.

I searched the registry to see if something was changed manually in HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server but only found one key: CustomerFeed.

share|improve this question
I wonder why microsoft tend to ignore those important bug reports that they always get – BornToCode Jan 26 '14 at 5:56
up vote 5 down vote accepted

According to AutoRecover information is not saved, SSMS 2012 only saves recovery files for queries that have been previously saved (which has led to some complaints). Files that have not been saved seem to get dumped in C:\Users\%USERNAME%\AppData\Local\Temp.

So you can check:

  • C:\Users\%USERNAME%\Documents\SQL Server Management Studio
  • C:\Users\%USERNAME%\AppData\Local\Temp

Personally I use TFS for version control on my queries and save them before every run. I've lost a fair number of queries in SSMS so I tend to be very careful.

If you can't find them on disk, there is a way to recover queries from the procedure cache as long as you catch them before they get pushed out of the cache. See also Execution Plan Caching and Reuse.

share|improve this answer
Thank you for the info. In my temp folder I just had an empty 0 bytes file .~sql file :( – BornToCode Jan 26 '14 at 5:57

I have fixed this problem in SSMSBoost add-in that I develop:

Autorecovery information is saved for all - saved and unsaved docs. You can even navigate through editor contents history and track executed queries.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.