Systems and records
Retiring an on-prem Dynamics CRM server: archive the history first
By SourceX Editorial · Updated
Short answer
Before retiring an on-premises Dynamics CRM server, capture its full history: a verified SQL Server backup of the organization database, attachments wherever they are stored, audit history, tracked email and the customizations that explain the fields. Then choose between migrating to Dynamics 365 online, archiving, or keeping a read-only server, because migrations usually move active records, not the whole trail.
Key takeaways
- End of support stops security updates; it does not delete anything, so the history survives only if someone archives it on purpose.
- Audit history, closed cases, old activities and offloaded attachments are the records migration plans most often leave behind.
- A SQL backup is complete but hard to read later, so pair it with a readable export of cases, notes and activities.
- A read-only CRM is created with security roles and disabled automation, and it still needs an owner and a shutdown date.
- Decide what to migrate only after the full archive exists and has been test restored.
What does end of support mean for an on-prem Dynamics CRM server?#
End of support for an on-premises Dynamics CRM version means Microsoft stops shipping security updates and fixes for it, while the server keeps running exactly as before. Nothing is deleted on the date, which is why many IT teams let the machine sit. The exposure grows quietly: an unpatched CRM server, often on an aging Windows Server and SQL Server stack, still holds years of customer conversations.
Dates differ by release, so check Microsoft's lifecycle pages for the exact version you run, whether that is Dynamics CRM 2016 or Dynamics 365 Customer Engagement (on-premises). Check the operating system and SQL Server version underneath it too. The practical deadline is whichever of the three ends first, or the date your infrastructure team wants the hardware back.
For a distributor, wholesaler or 3PL, that CRM usually holds more than contacts. Customer service cases, delivery complaints, quote follow-ups and account notes record how the business handled problems, and that trail is hard to rebuild once the server is gone.
What history lives in an on-prem Dynamics CRM deployment?#
An on-prem Dynamics CRM deployment keeps almost everything in its SQL Server organization database, next to a configuration database that describes the deployment itself. That covers standard entities, the custom entities a partner built over the years, notes, and in many deployments the attachment files too.
Count each record family below before scoping the retirement. Migration plans tend to focus on accounts, contacts and open opportunities and quietly skip the rest.
| Record family | What it captures | Why keep the history |
|---|---|---|
| Cases and resolutions | Customer issues, status changes, resolution notes | Shows how service problems were actually solved |
| Activities | Emails, phone calls, tasks and appointments linked to records | Connects conversations to accounts and outcomes |
| Notes and attachments | Free-text notes, proof of delivery files, photos, signed quotes | Holds the detail that structured fields miss |
| Audit history | Who changed which field, from what value, and when | Proves the sequence of decisions and edits |
| Quotes, orders and opportunities | Pricing discussions and won or lost deals | Links sales activity to results |
| Customizations and processes | Custom entities, fields, option sets, workflows, plug-ins | Explains what each field meant at the time |
- 01Your work records
- 02Personal details removed
- 03You approve the release
- 04Licensed to AI developers
The archive checklist before the server goes dark#
The archive checklist starts with the databases and works outward to the pieces that live elsewhere or depend on them. Work through it while the server, its service accounts and the people who administered it are still available.
- Take a full SQL Server backup of the organization database and the configuration database, then restore both on a separate server to prove the backup works.
- Confirm where attachments live: inside the database, or offloaded by an add-on to SharePoint, cloud storage or a file share. Export the files from wherever they actually sit.
- Check whether auditing was enabled, for which entities, and whether older audit logs were ever deleted. Export audit history before any cleanup job runs.
- Document how email was tracked: the Outlook client, the Email Router or server-side synchronization. Tracked messages sit in CRM; untracked mail stays only in mailboxes.
- Export the managed and unmanaged solutions so custom entities, option set labels and field definitions can be read later.
- Record row counts per entity, date ranges and the exact CRM build, and store that summary with the backup.
- Save a readable copy of the core entities, such as cases with their notes and activities, as CSV or JSON.
Migrate to Dynamics 365 online, archive, or keep it read-only?#
The choice between migrating, archiving and keeping a read-only server depends on which records people still open every day and which only need to survive. Most companies end up with a mix: active records move, the full history is archived, and the old server stays read-only for a defined period.
If your migration partner proposes a cutoff date for history, ask what happens to everything older. A specific answer, such as a verified backup plus readable exports owned by IT, beats an assumption that someone will deal with it later.
| Option | What it keeps | Watch for |
|---|---|---|
| Migrate to Dynamics 365 online | Active records, customizations, selected history | Plans often skip audit history, old activities and closed cases to save effort |
| Archive to backup plus readable export | Everything, including audit history and attachments | Needs a documented restore path and a named owner |
| Keep a read-only server | The familiar interface over the full history | Still needs patching, licensing and an end date |
| Third-party archive tool | Searchable history outside CRM | Check what it imports, especially notes and audit data |
How to keep an old Dynamics CRM read-only without breaking the trail#
A read-only Dynamics CRM is created by changing security roles and switching off automation, not by stopping services. Give users a role with read privileges only, deactivate workflows and plug-in steps that write data, and stop email synchronization so nothing new is tracked into old records.
Isolate the server on the network, limit access to a named group, and document the service accounts. Put the read-only server's retirement date on the IT calendar with an owner, because a temporary server nobody owns tends to become permanent and unpatched.
Illustrative: a distributor retires its CRM server#
Illustrative: a fictional industrial distributor runs customer service on an on-prem Dynamics CRM 2016 server. Cases record backorders, damaged shipments and pricing disputes, and inside sales reps track email through the Outlook client. The company is moving to Dynamics 365 online with its ERP partner.
The partner's plan migrates accounts, contacts and open cases. The IT lead inserts an archive phase first: a verified SQL backup, an export of every closed case with its notes and activities, attachments pulled from a file share an old add-on had used, and the audit log for the case entity. The old server then runs read-only until customer service signs off, and is shut down.
Later, during a company-wide records inventory, the closed-case archive turns out to be the most complete record of how the business resolved shipping exceptions. Because it exists in readable form, the company can describe it in a metadata-only fit check without restoring anything.
How SourceX approaches a retiring CRM#
SourceX treats a retiring CRM as a records question before it is a licensing question. In the Supply step of the SourceX five-step transaction, a company describes systems, record families and date ranges as metadata only; no files are shared during the initial assessment. Rights, Preparation, Approval and Delivery follow only if the supplier chooses to continue.
Archive notes from the retirement, such as backup dates, row counts and the export method used, make provenance far easier to document in a SourceX Evidence Packet if a package proceeds. Data is licensed, not sold outright, and the company keeps ownership of its records.
Frequently asked questions
Can audit history be carried into Dynamics 365 online?
Not always in the form people expect. Audit records are system data, and many migration approaches do not bring them across as live audit history. Ask your partner exactly what happens to audit logs, and export them to a readable archive before cutover either way, so the record of who changed what survives the move.
How long should the read-only server keep running?
Long enough for users to confirm that the new system and the archive cover what they need, and no longer than your security team is willing to support it. Set a firm date, assign an owner, and agree in advance what triggers shutdown, such as sign-off from customer service, finance and legal.
What about emails that were never tracked in CRM?
Untracked email lives only in Exchange or Microsoft 365 mailboxes, not in the CRM database, so it follows your email retention rules. If that correspondence matters, check that departed users' mailboxes were kept. The CRM archive cannot recover messages it never received.
Do we need the same CRM version to read the SQL backup later?
To use the backup as a working CRM, you generally need a compatible CRM and SQL Server setup. The raw tables can be queried with SQL Server alone, but the structure is hard to interpret without documentation. That is why exported solutions and readable files should sit next to the backup.
Is old CRM history worth anything outside the company?
It can be, when cases, activities and outcomes are linked and the company has the rights to license them. Value depends on drivers such as uniqueness, domain expertise, recency, data cleanliness and privacy burden. A metadata-only review is a safe first step, and nothing needs to leave your systems for it.
Related resources
- QuestionCan SaaS data be licensed?
- InsightPurpose limitation: can records collected for one purpose be licensed for AI?
- InsightShared inboxes like support@ and sales@: often your most licensable email
- InsightIs B2B contact data personal data under CCPA?
- IndustryBPO & contact centers data
- IndustryIT managed services data
See if your company qualifies
A short company assessment. No data uploads are needed.