Data elements that aren't copied during refresh

Data elements that aren't copied during refresh

Nghia Song - Microsoft Dynamics 365 Technical Consultant

Nghia Song
Tel - WhatsApp: +84967324794
Email: songnghia.uit@gmail.com

When refreshing a production environment to a sandbox environment, or a sandbox environment to another sandbox environment, there are certain elements of the database that are not copied over to the target environment. These elements include:

Email addresses in the LogisticsElectronicAddress table.
Batch job history in the BatchJobHistory, BatchHistory, and BatchConstraintHistory tables.
SMTP Relay server in the SysEmailParameters table.
Print Management settings in the PrintMgmtSettings and PrintMgmtDocInstance tables.
Environment-specific records in the SysServerConfig, SysServerSessions, SysCorpNetPrinters, SysClientSessions, BatchServerConfig, and BatchServerGroup tables.
Document attachments in the DocuValue table. These attachments include any Microsoft Office templates that were overwritten in the source environment.
All users except the admin will be set to Disabled status.
All batch jobs are set to Withhold status.
All users will have their partition value reset to the "initial" partition record ID.
All Microsoft-encrypted fields will be cleared, because they can't be decrypted on a different database server. An example is the Password field in the SysEmailSMTPPassword table.