Since upgrading from SQL Server Management Studio 2008 R2, I've noticed that it no longer autosaves queries that have not been manually saved first. If a file has been manually saved the autorecover files end up in the following directory:
%appdata%\Microsoft\SQL Server Management Studio\11.0\AutoRecoverDat\Solution1
However, I have ended up in the situation where I have unsaved queries when my computer has crashed and have not been able to recover them.
I have also found references to .sql files stored in temp files in the following directory, but the files here seem to be very haphazardly caught:
I have seen recommendations to use SSMS Tools but this has fairly significant licensing fees.
I'm currently testing out another add-in called SSMSBoost (under the community license), which has a lot of nice features and will probably solve my problem, but it seems crazy to need to use a third party add-in just to have some basic auto recovery features.
Does anyone have any other solutions?