Recover unsaved SQL query scripts

Question

How to recover the unsaved scripts if the SSMS crashes   unsaved tab gets accidentally closed

User · Answer

For SSMS 18  specifically 18 6   I found my backup here C  Windows SysWOW64 Visual Studio 2017 Backup Files Solution1  Kudos to Matthew Lock for giving me the idea to just search across my whole machine

User · Answer

Use the following location where you can find all  AutoRecover  vs  sql  autorecovery files    C  Users  lt YourUserName gt  Documents SQL Server Management Studio Backup Files Solution1

User · Answer

You can find files here  when you closed SSMS window accidentally  C  Windows System32 SQL Server Management Studio Backup Files Solution1

User · Answer

For SSMS 18  I found the files at  C  Users YourUserName Documents Visual Studio 2017 Backup Files Solution1  For SSMS 17  It was used to be at  C  Users YourUserName Documents Visual Studio 2015 Backup Files Solution1

User · Answer

A bit late to the party  but none of the previously mentioned locations worked for me - for some reason the back up autorecovery files were saved under VS15 folder on my PC  this is for SQL Server 2016 Management Studio   C  Users YOURUSERNAME Documents Visual Studio 2015 Backup Files Solution1  You might want to check your Tools-Options-Environment-Import and Export Settings  the location of the settings files could point you to your back up folder - I would never have looked under the VS15 folder for this

User · Answer

I know this is an old thread but for anyone looking to retrieve a script after ssms crashes do the following   Open Local Disk  C   Open users Folder Find the folder relevant for your username and open it Click the Documents file Click the Visual Studio folder or click Backup Files Folder if visible  Click the Backup Files Folder Open Solution1 Folder  Any recovered temporary files will be here  The files will end with vs followed by a number such as vs9E61  Open the files and check for your lost code  Hope that helps  Those exact steps have just worked for me  im using Sql server Express 2017

User · Answer

Posting this in case if somebody stumbles into same problem   Googled for Retrieve unsaved Scripts and found a solution   Run the following select script  It provides a list of scripts and its time of execution in the last 24 hours  This will be helpful to retrieve the scripts  if we close our query window in SQL Server management studio without saving the script  It works for all executed scripts not only a view or procedure   Use  lt database gt  SELECT execquery last execution time AS  Date Time   execsql text AS  Script  FROM sys dm exec query stats AS execquery CROSS APPLY sys dm exec sql text execquery sql handle  AS execsql ORDER BY execquery last execution time DESC

User · Answer

Go to SSMS    Tools    Options    Environment    AutoRecover  There are two different settings   1  Save AutoRecover Information Every Minutes  This option will save the SQL Query file at certain interval  Set this option to minimum value possible to avoid loss  If you have set this value to 5  in the worst possible case  you can lose last 5 minutes of the work   2  Keep AutoRecover Information for Days  This option will preserve the AutoRecovery information for specified days  Though  I suggest in case of accident open SQL Server Management Studio right away and recover your file  Do not procrastinate this important task for future dates

User · Answer

You may be able to find them in one of these locations  depending on the version of Windows you are using    Windows XP  C  Documents and Settings YourUsername My Documents SQL Server Management Studio Backup Files    Windows Vista 7 10   USERPROFILE  Documents SQL Server Management Studio Backup Files   OR   USERPROFILE  AppData Local Temp   Googled from this source and this source

User · Answer

I use the free file searching program Everything  search for   sql files across my C  drive  and then sort by Last Modified  and then browse by the date I think it was probably last executed  It usually brings up loads of autorecovery files from a variety of locations  And you don t have to worry where the latest version of SSMS VS is saving the backup files this version

User · Answer

SSMSBoost add-in  currently free     keeps track on all executed statements  saves them do disk  regulary saves snapshot of SQL Editor contents  You keep history of the modifications of your script  Sometimes  the best  version is not the last and you want to restore the intermediate state  keeps track of opened tabs and allows to restore them after restart  Unsaved tabs are also restored     tons of other features   I am the developer of the add-in

User · Answer

I was able to recover my files from the following location   C  Users  lt yourusername gt  Documents SQL Server Management Studio Backup Files Solution1   There should be different recovery files per tab   I d say look for the files for the date you lost them

User · Answer

Maybe you don t find the suggested directories or your recovery file is missing  thanks god I replicated the crash with an unsaved script and lead me to this directory   C  Users user OneDrive Documents Visual Studio 2015 Backup Files Solution1  So  maybe this saves your day

User · Answer

I am using Windows 8 and found the missing scripts in the path below   C  Users YourUsername Documents SQL Server Management Studio Backup Files

[sql] Recover unsaved SQL query scripts

Examples related to sql

Examples related to sql-server

Examples related to tsql

Examples related to sql-server-2012

Examples related to ssms