When moving SQL Files within same server but different disks/volumes the SQL Task Detach/Attach can be used.

However must DB owner be verified to be set to ‘sa’ and the following command must be run.

ALTER DATABASE CM_PS1 SET TRUSTWORTHY ON

Otherwise is there errors in SMS Provider Log and SMS Policy Provider log.