Contents
What is site database?
The site database server is a computer that runs a supported version of Microsoft SQL Server. SQL Server is used to store information for Configuration Manager sites. Each site in a Configuration Manager hierarchy contains a site database and a server that is assigned the site database server role.
What is a configuration table in database?
Configuration tables are used for Things, Thing Templates, Thing Shapes, and Mashups to store values, such as property values, that do not change often. Configuration tables should not be used for storing dynamic data that gets updated frequently. This information is defined in a similar way to properties.
What database does a website use?
MySQL – MySQL is probably the most common database on the web. It’s free to use and open source, so a lot of projects have been built around it. This is the database system that WordPress and most of the popular content management systems use.
What happens when you modify the database configuration for a site?
When you modify the database configuration for a site, Configuration Manager restarts or reinstalls Configuration Manager services on the site server and remote site system servers that communicate with the database. Run Configuration Manager setup on the site server, and select the option Perform site maintenance or reset this site.
How to configure a site to use a SQL Server database?
When you run Configuration Manager setup to configure a site to use the database in an availability group, each secondary replica server must have a SQL Server file path that’s identical to the file path for the site database files on the current primary replica.
How to recover the site database in Configuration Manager?
Configuration Manager can recover the site database from any of the following processes: After you restore the site database by using a method outside Configuration Manager, run Setup, and select this option to complete the site database recovery.
Why do we split the site and monitor databases?
Split the monitor and logging databases from site database as part of best practices which will eventually help to resolve excessive growth of site database and improve the performance. Site: (also known as Site Configuration) stores the running Site configuration, plus the current session state and connection information.