Placing database for the sites in Configuration Manager hierarchy is going to be one of the very important task of the planning and designing phase.
Below quick points to be considered,
- Site Database is server which runs the supported version of SQL to host the database for storing information of Configuration Manager.
- Site Database can be Site server, or it can be hosted on Remote server.
- On Central Administration Site and Primary Site full version of SQL should installed
- On secondary site SQL express can be installed instead SQL full version.
- Need to make sure high bandwidth, high availability, and speed between Site server a remote server where you decided to host the database as some of the sites server and site systems constantly talk to Database server.
- For SQL always on availability database recovery model need to be set to full.
- For SQL non-availability database recovery model need to be set to simple.
- Default instance of SQL server can be used.
- SQL server must be part of domain where all sites servers are part of it with two-way trust to site servers and computers running SMS provider.
- Failover cluster for SQL can not be use when database is on site server.
Please share your valuable comments.