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.

Important

Database maintenance or repair operations that can result in data loss, such as DBCC CHECKDB WITH REPAIR_ALLOW_DATA_LOSS, are not supported.

In this section

Dynamics 365 organization database indexes

See Also

Back up the Microsoft Dynamics 365 System
Update Microsoft Dynamics 365
Overview of SQL Server Servicing Installation
Server Performance and Activity Monitoring