Hello Mak ,

I think you had restored the database by this procedure :

1- Take instance offline

2- Move mdf ,ndf and ldf files to target server

3- Reattach these files to restore database

IF (I AM Right)

Begin

solution 1

1- configure Dummy replication to create distribution DB on Target server

2- then u can run sp_dbremovereplication or u can manually remove the Publication .

3- Disable the Dummy replication

End