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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

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

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

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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