February 16, 2014 at 6:48 pm
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:
%userprofile%\AppData\Local\Temp
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?
October 5, 2014 at 12:34 pm
This article points out the option to use the query statistic cache from SQL server. You can get the actual SQL using sys.dm_exec_sql_text.
Hope that helps:
http://ozkary.blogspot.com/2014/09/recover-sql-server-management-studio.html
October 5, 2014 at 11:15 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply