Thanks Steve. Hopefully it'll be ok this morning. I appreciate you taking the time to advise me.

Kind regards

You were correct Steve. The publication was finally dropped. 😀 There are 171880 tables in the database I want to clone. Perhaps replication isn't the best way to go about this. I may tell the users an overnight restore from live will have to suffice and they'll have to make do with day old data.