Microsoft Dynamics 365 database maintenance
Applies To: Dynamics 365 (on-premises), Dynamics CRM 2016
A Microsoft Dynamics 365 deployment consists of the following databases:
MSCRM_CONFIG. A single database that contains Microsoft Dynamics 365 metadata, such as configuration and location information that is specific to each organization database.
OrganizationName_MSCRM. One or more organization databases. This is the database where Microsoft Dynamics 365 data is stored, such as all records and activities, and metadata details like entity relationships.
Database maintenance for the Dynamics 365 databases should include regular backups, frequent security patch evaluation, and health check monitoring.
Database maintenance or repair operations that can result in data loss, such as DBCC CHECKDB WITH REPAIR_ALLOW_DATA_LOSS, are not supported.