blocks|key|153850|text|参加聚会有点晚了，但前面提到的位置都不适合我-出于某种原因，备份/自动恢复文件保存在我PC上的VS15文件夹下(这是用于SQL+Server+2016+Management+Studio的)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|153851|C:\Users\YOURUSERNAME\Documents\Visual+Studio+[version]\Backup+Files\Solution1|code-block|syntax|javascript|153852|例如：|153853|C:\Users\YOURUSERNAME\Documents\Visual+Studio+2015\Backup+Files\Solution1|153854|您可能想要检查您的工具-选项-环境-导入和导出设置，设置文件的位置可能会指向您的备份文件夹-我永远不会在VS15文件夹下查找它。|153855|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

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)
<pre><code>C:\Users\YOURUSERNAME\Documents\Visual Studio [version]\Backup Files\Solution1
</code></pre>
ex:
<pre><code>C:\Users\YOURUSERNAME\Documents\Visual Studio 2015\Backup Files\Solution1
</code></pre>
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.

blocks|key|153804|text|也许你没有找到建议的目录，或者你的恢复文件丢失了，感谢上帝，我用一个未保存的脚本复制了崩溃，并将我带到了这个目录：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|153805|C:\Users\user\OneDrive\Documents\Visual+Studio+2015\Backup+Files\Solution1+1|153806|因此，这也许可以节省您的时间:)|153807|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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 :)

blocks|key|371961|text|对于SSMS+18，我在以下位置找到了这些文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|371962|C:\Users\YourUserName\Documents\Visual+Studio+2017\Backup+Files\Solution1|code-block|syntax|javascript|371963|对于SSMS+17，它通常位于：|371964|C:\Users\YourUserName\Documents\Visual+Studio+2015\Backup+Files\Solution1|371965|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

For SSMS 18, I found the files at:
<pre><code>C:\Users\YourUserName\Documents\Visual Studio 2017\Backup Files\Solution1
</code></pre>
For SSMS 17, It was used to be at:
<pre><code>C:\Users\YourUserName\Documents\Visual Studio 2015\Backup Files\Solution1
</code></pre>

blocks|key|371810|text|我使用的是Windows+8，在下面的路径中找到了缺少的脚本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|371811|C:\Users\YourUsername\Documents\SQL+Server+Management+Studio\Backup+Files|code-block|syntax|javascript|371812|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I am using Windows 8 and found the missing scripts in the path below:

<pre><code>C:\Users\YourUsername\Documents\SQL Server Management Studio\Backup Files
</code></pre>

blocks|key|371854|text|转至SSMS+>>+Tools+>>+Options+>>+>>+AutoRecover|type|unstyled|depth|inlineStyleRanges|entityRanges|data|371855|有两种不同的设置：|371856|1)每分钟保存一次AutoRecover信息|371857|此选项将按一定的时间间隔保存SQL查询文件。将此选项设置为可能的最小值，以避免丢失。如果您将此值设置为5，在最坏的情况下，您可能会丢失最后5分钟的工作。|371858|2)将AutoRecover信息保存几天|371859|此选项将保留指定日期的AutoRecovery信息。不过，我建议如果发生意外，立即打开SQL+Server+Management+Studio并恢复您的文件。不要把这个重要的任务拖到未来的日子里。|371860|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

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.

blocks|key|371773|text|当您意外关闭SSMS窗口时，您可以在此处找到文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|371774|C:\Windows\System32\SQL+Server+Management+Studio\Backup+Files\Solution1|code-block|syntax|javascript|371775|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can find files here, when you closed SSMS window accidentally

<pre><code>C:\Windows\System32\SQL Server Management Studio\Backup Files\Solution1
</code></pre>

blocks|key|153715|text|我能够从以下位置恢复我的文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|153716|C:\Users\<yourusername>\Documents\SQL+Server+Management+Studio\Backup+Files\Solution1|code-block|syntax|javascript|153717|每个选项卡应该有不同的恢复文件。我要说的是查找你丢失文件的日期。|153718|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I was able to recover my files from the following location:

<pre><code>C:\Users\&lt;yourusername&gt;\Documents\SQL Server Management Studio\Backup Files\Solution1
</code></pre>

There should be different recovery files per tab. I'd say look for the files for the date you lost them.

blocks|key|372065|text|我使用免费的文件搜索程序Everything，在我的C:盘上搜索*.sql文件，然后按上次修改时间排序，然后按我认为可能是上次执行的日期浏览。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|372066|它通常会从不同的位置加载自动恢复文件。您不必担心最新版本的SSMS/VS会将此版本的备份文件保存到何处。|372067|​|372068|📷|atomic|372069|372070|entityMap|0|LINK|mutability|MUTABLE|url|https://www.voidtools.com/|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6240d9ecbc0f5d604fd6e1c3b8a5ad5d.png|imageAlt^0|C|A|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|14|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|K|3|G|5|6|7|19|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|U|P|V|C|$W|X|Y|-4]]]]

I use the free file searching program <a href="https://www.voidtools.com/" rel="nofollow noreferrer">Everything</a>, 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.
<a href="https://i.stack.imgur.com/NUrV7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NUrV7.png" alt="enter image description here" /></a>

blocks|key|372109|text|对于SSMS18(特别是18.6)，我在这里找到了我的备份C:\Windows\SysWOW64\Visual+Studio+2017\Backup+Files\Solution1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|372110|感谢Matthew+Lock给了我在整个机器上搜索的想法！|372111|entityMap^0|T|1P|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

For SSMS 18 (specifically 18.6), I found my backup here <code>C:\Windows\SysWOW64\Visual Studio 2017\Backup Files\Solution1</code>.
Kudos to Matthew Lock for giving me the idea to just search across my whole machine!

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

Recover unsaved SQL query scripts

Visual Studio

SQL Server

Windows

如果SSMS崩溃/未保存选项卡意外关闭，如何恢复未保存的脚本？

问恢复未保存的SQL查询脚本
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问恢复未保存的SQL查询脚本EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问恢复未保存的SQL查询脚本
EN