SharePoint Database

As they all know, Microsoft SharePoint Portal Server is used to generate portals smart to seamlessly connect users, teams & knowledge that allows us to take advantage of relevant information across business processes.In this situation, it is imperative to cross-use the data stored in SharePoint & other applications where it intends to use the same data, which is entering through graphical user interface of SharePoint. The actual cost, time & productivity advantage of SharePoint can be used by ourselves to permit the use of portals & data entered through these for integration with other applications without problems.
As such, we have no control over how information is stored within a SharePoint portal but that should not be a limitation in the design of user interfaces with SharePoint. SharePoint provides methods to play with all the data you want to integrate with other external applications to SharePoint. Principally, SharePoint Portal Server and Windows SharePoint Services uses a database from SQL Server to store all your documents, web pages, and metadata. Another database is used to store the configuration details. In fact, almost everything related to SharePoint is stored in a SQL Server 2000 or MSDE database. By its very design, the database is the heart of SharePoint, and developers must be familiar with their format to make use of it.
During installation, you can define whether the SharePoint database is to MSDE or SQL Server 2000. SharePoint data is stored in a relational database either using MSDE or SQL Server 2000 in terms of how it was installed. All SharePoint data can be seen in Enterprise Manager on the SQL server involved.



The database name differs based on how portals have been appointed there. Some critical databases and nomenclature of SharePoint are like this:

• Finish _SITE database: stores all the contents of a specific portal. Contains files, web pages, websites, sites, and all things related to SharePoint infrastructure.
• Finish _PROF database: stores all information about user profiles, but also holds the details of what information we collect on different user profiles.
  
• Ending _SERV database: Stores data for searching, reporting, and indexing. It stores the gatherer log information as well as text indexes content that is crawled. In fact it can be easily controlled by the right mouse button on any of the databases and choosing Properties. In fact, this could be one way of knowing how much space each function or activity on your site, you are assuming.

From the standpoint of the developer, the _SITE _SERV and databases are very important. The database has several very important _SERV tables - srch_GathererLog_ * (which could be many tables) srch_docsspecialprops and sub_PropVersions. Each of these tables contain data about searching. Srch_GathererLog_ * The pictures have all registration information gatherer logs. SharePoint can not clear the accumulator of user interface and this can only be done through Enterprise Manager.



The srch_docsspecialprops & sub_PropVersions contain data about the files that have been indexed. Srch_dock-striker The table includes information such as title, author, verbal description, etc. for all files crawled as tables source.The external file in the database tables _SITE are important. There are tables like Webs, Google Docs, DocVersions, and lists. These tables have a positive content by name. Table of websites containing information about networking in the vein portae table documents the path contains the names and actual content of all documents on its portal infrastructure.
One can look in the documentation & DocVersions tables to decide the number of documents & versions of documents in the portal quickly. In fact, the number of rows in the Docs table tell the number of documents in that particular table. The same is true for DocVersions table. The number of files shown in the SharePoint object model will be different, since it also has all the aspx files & webParts (. DWP) records to tell the number, not the user stored files.