Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSMS Auto-recovery/Auto-save new (unsaved) queries Expand / Collapse
Posted Sunday, February 16, 2014 6:48 PM


Group: General Forum Members
Last Login: Wednesday, February 19, 2014 4:07 PM
Points: 101, Visits: 78
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?
Post #1541960
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse