Delete backup history mssql server

DeleteBackupHistory.sql

set xact_abort on
declare @media_set_id int = 6089
use msdb
begin tran

delete from backupfile 
where exists 
    (select null 
    from backupset
    where backupset.backup_set_id = backupfile.backup_set_id
	   and media_set_id = @media_set_id
    )

delete from backupfilegroup
where exists 
    (select null 
    from backupset
    where backupset.backup_set_id = backupfilegroup.backup_set_id
	   and media_set_id = @media_set_id
    )

delete from backupset
where media_set_id = @media_set_id

delete from backupmediafamily
where backupmediafamily.media_set_id = @media_set_id

delete from backupmediaset
where media_set_id = @media_set_id


rollback tran
--commit tran