Stop tenant database mirroring.
You must have the AlterTenantMirroring, DropDatabase, and StartStopDatabase privileges
Removing the mirroring configuration from a tenant database involves stopping and dropping the mirror so that the database no longer runs in a mirroring system.
If the tenant database has scale-out database copies, the read-only scale-out configuration is intact.
The mirror database is dropped and the read-write database that is running as the primary database is no longer involved in a mirroring system.