SQL Studio - Recover previously unsaved .sql

[mpalmer]

Recover previously unsaved .sql files with SQL Studio?

[alexa]

You can select the restorable file types in the 'Environment -> Documents -> Restore' section of the 'Options' window (select 'Tools -> Options...' from the main menu).

[mpalmer]

Right...but how do I recover previous .sql files?

[alexa]

The restorable files with corresponding paths are specified in the *.xml file that is located in the following folder:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\

[mpalmer]

First...it's strange that I have to find a hidden .xml file and decipher it to locate the files. Second, it's even stranger that the saved files are stored as .cache files and I have to rename them to .sql. SQL Studio doesn't have functionality within the program to explore and recover previously saved files???

The previously unsaved files are not in the recovery directory - why would they have been deleted?

[alexa]

This may happen due to abnormal program termination or system shutdown.

Did you exit dbForge correctly before the files were lost?

[mpalmer]

I'm not sure...but the point of being able to restore is largely applicable to application crashes. This should be a standard feature. I've used other SSMS alternatives that do exactly this.

Recovering from a crash is the main purpose of restoring unsaved files

Also, why doesn't SQL Studio have the functionality to restore previous files from within the program, rather than have to open an .xml file??

[mpalmer]

Can someone help me understand the purpose fo this functionality if it can't recover .sql files after a crash?

[alexa]

We will investigate this issue and will answer you as soon as possible.