purge-version-members-master-data-services.md

title	Purge Version Members
description	Purge Version Members (Master Data Services)
author	meetdeepak
ms.author	dkhare
ms.reviewer	mikeray
ms.date	03/05/2026
ms.service	sql
ms.subservice	master-data-services
ms.topic	how-to
ms.custom	build-2025

Purge Version Members (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

In [!INCLUDEssMDSshort], deleting a member only deactivates, or soft-deletes, it. The data still resides in the database. This topic describes how to purge (permanently delete) all soft-deleted members in a model version.

Prerequisites

To perform this procedure.

• You must have permission to access the Version Management functional area.

• You must be a model administrator. For more information, see Administrators (Master Data Services).

To purge soft-deleted members

1. In [!INCLUDEssMDSmdm], click Version Management.

2. On the Manage Versions page, select the model that has the version that you want to purge. The list of model versions is displayed.

3. Select the row for the version that you want to purge.

4. Click Purge Members.

5. Click "OK" on the confirmation prompt.

Additional Methods to Purge Members

Purging version members permanently delete soft-deleted members in all entities pertaining to the selected version. A more finely grained alternative is to use entity base staging to permanently delete only specific members of an entity. Also, entity administrators with Explorer functional permission may purge an entity version in the entity explorer page.

For more information, see Leaf Member Staging Table (Master Data Services)