我如何找到MSSMS数据库？ [英] How do I find my MSSMS database?

问题描述

听起来很傻我知道，但我在MSSMS中创建了一个数据库，用数据填充它，现在无法在任何地方找到它。我可以在MSSMS中打开它，做我想做的任何事情，但在我的电脑上无法找到它。我使用了许多配置的资源管理器，它找不到它。我甚至用'* .mdf'搜索仍然没有找到我的文件，我手动查看了我能想到的任何地方，没有运气。



有没有人知道我的.mdf哪里去了哪里？



darby

当你出生时，你哭了，世界很高兴。

住你的生活所以当你死的时候，世界会哭泣，你会高兴！

~古老的印度谚语〜



< b>我尝试了什么：



手动搜索，Windows资源管理器使用许多不同的搜索条件

Sounds silly I know, but I created a database in MSSMS, filled it with data and now can not find it anywhere. I can open it in MSSMS, do anything I want to it but can not find it anywhere on my computer. I have used Explorer with many configurations and it can't find it. I even searched using just '*.mdf' still didn't find my file, I've manually looked everywhere I can think of with no luck.

Does anybody have any idea Where oh where has my .mdf gone?

darby
"When you were born, you cried and the world rejoiced.
Live your live so that when you die
the world cries and you rejoice!"
~Old Indian Proverb~

What I have tried:

Manual searches, and Windows Explorer using many different search criteria

推荐答案

打开SSMS，右键单击对象资源管理器窗格中的主服务器名称节点。

选择属性，然后在出现的对话框中选择数据库设置页面。左边的列表。

底部附近是数据库默认位置：数据框提供SQL Server存储其数据库文件的文件夹。

Open SSMS, and right click the main server name node in the "Object Explorer" pane.
Select "Properties", and in the resulting dialog select the "Database Settings" page from the list on the left.
Near the bottom is the "Database default locations": the "Data" box gives the folder where SQL Server stores its database files.

这篇关于我如何找到MSSMS数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！