SharePoint 2007 内容数据库在哪里？
DBA 想知道我支持哪些数据库。我还没有找到这些数据库服务器上的信息。 我尝试了以下方法：
- 根据此博客，我读到默认目录是 C:\Program Files\MS SQL\Data 内容数据库 – 更改默认位置。我没有找到mdb文件。
- 我查看了 Sharepoint Central Administration >应用管理>内容数据库并找到内容数据库名称，但我在 SharePoint 的中央配置 Web.config 中找不到该名称。
- 如果它在实例的 Web.config 中，我还没有找到它。
DBA 认为我每个站点都有不同的数据库，但我无法确认这一点。预先感谢您能给我的任何指导。
The DBA's want to know which databases I'm supporting. I haven't found what database servers these are on.
I have tried the following approaches:
- I have read that the default is the directory, C:\Program Files\MS SQL\Data, according to this blog Content Database – Changing Default Location. I didn't find an mdb file.
- I have looked in Sharepoint Central Administration > Application Management > Content Databases and found a content database name, but I couldn't find that in SharePoint's Central Configuration Web.config.
- If it's in the instance's Web.config, I haven't found it.
The DBA's think that I have a different database for each site, but I cannot confirm this. Thanks in advance for any direction you can give me.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您所指的默认位置是 SQL 数据库的默认位置。
转至 Sharepoint 中央管理 >应用管理>内容数据库
将 Web 应用程序（在屏幕右侧）更改为您正在查找的网站
此页面应告诉您数据库名称和数据库服务器。复制数据库服务器和 SQL Server 数据库名称。
这应该是 DBA 正在寻找的信息。
每个 Web 应用程序至少有一个数据库，但也可以有多个数据库，具体取决于 SharePoint 环境的配置方式。您将在步骤 2 中的“管理内容数据库”网站上看到每个网站有多少个内容数据库。
这些步骤向您显示内容数据库，但 SharePoint 还使用其他数据库进行配置和共享服务。
希望这有帮助！
更新：
PROD_APPNAME_Search - 我认为这是您的搜索数据库。确认去
到中央管理>操作>服务器上的服务>视窗
SharePoint Services 帮助搜索
PROD_APPNAME_SharePoint_Config - 共享点的配置数据库。请参阅 SharePoint 服务器上的 SharePoint 产品和技术配置向导
PROD_APPNAME_SSP_DB - SSP 数据库（应该能够确认这一点
从下面的步骤）
PROD_APPNAME_SSP_Search_DB - 搜索数据库
（应该能够从下面的步骤中确认这一点）
PROD_APPNAME_SSP_WEB_APP - 可能是 SSP 的内容数据库
（应该能够在我原始回复的步骤中看到这一点）
PROD_APPNAME_WEB_APP - 内容数据库？ （应该可以在我原始回复的步骤中看到这一点）
看起来无论是谁设置你的农场都使用命名格式 PROD_APPNAME_ 设置数据库，这是推荐的。
要查看 SSP DB，请转至 http://[服务器名称]/_admin/managessp.aspx。对于每个 SSP（您可能只有一个），单击编辑属性。
The default location you are referring to is the default location for SQL databases.
Go to Sharepoint Central Administration > Application Management > Content Databases
Change the Web application (on the right hand side of the screen) to the site you are looking for
Click on the Database Name
This page should tell you the database name and the database server. Copy both the Database server and the SQL server database name.
This should be the information the DBA's are looking for.
At a minimum you will have a Database per Web Application, but you can also have more than one, depending on how your SharePoint environment has been configure. You will see how many content databases you have per site on the "Manage Content Databases" site from step 2.
These steps show you the Content Databases, but SharePoint also uses additional databases for config and shared services.
Hope this helps!
UPDATE:
PROD_APPNAME_Search - I think this is your serach DB. To confirm go
to Central Administration > Operations > Services on Server > Windows
SharePoint Services Help Search
PROD_APPNAME_SharePoint_Config - Config DB for sharepoint. See this in the SharePoint Products and Technologies Configuration Wizard on the SharePoint server
PROD_APPNAME_SSP_DB - SSP Database (should be able to confirm this
from the step below)
PROD_APPNAME_SSP_Search_DB - Search Database
(should be able to confirm this from the step below)
PROD_APPNAME_SSP_WEB_APP - probably the content DB for the SSP
(should be able to see this in the steps from my original reply)
PROD_APPNAME_WEB_APP - content DB? (should be able to see this in the steps from my original reply)
It looks like whoever setup your farm setup the DBs with the naming format PROD_APPNAME_, which is recommended.
To see the SSP DB's go to http://[servername]/_admin/managessp.aspx. For each SSP (you will probably only have one) click edit properties.
您很可能每个 Web 应用程序都有一个内容数据库。
要查看它们，请转至
http://CENTRAL_ADMIN/_admin/CNTDBADM.aspx并选择您想要其信息的 Web 应用程序。单击内容数据库名称时，您将获得以下详细信息：使用该信息，您可以跟踪 SQL Server 中的物理文件，转到“属性”>“内容数据库”。 SQL Management Studio 上的文件。
You most likely have one Content Database per Web Application.
Too see them, go to
http://CENTRAL_ADMIN/_admin/CNTDBADM.aspxand choose the Web Application you want the info for. When you click the Content Database name, you get details such as:With that info, you can trace the physical files from SQL Server, go to
Properties > Fileson the SQL Management Studio.您可以通过
来了解此数据库的文件所在的位置
You can tell which database server your databases are on by
You can tell where the files for this database is located by