Microsoft SharePoint is a collaboration platform that stores many objects such as:
- Lists
- Libraries
- Content types
- Sites/Sub sites
- Site Pages
In SQL Server databases. They are broadly classified into namely the following two categories:
- Config Database.
- Content database.
Suppose you are on a SharePoint farm server and want to know where your SharePoint database is hosted. The task is simplied by a registry entry. To locate where the databases are present, issue the following command in Regeditor.
- Look for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\[15.0|14.0|12.0]\Secure\ConfigDb
- And open the key “DNS” to get the connection string of the SharePoint database.
Happy SharePointing :-)