This site is no longer available. (MU Multisite)

Need help to fix please

trying to resolve to http://www.sweetsorella.com FAILS
but relsovess to https://www.sweetsorella.com

All the other websites on the multisite are gine and working coreectly!

Background:

1. I archived the site , then I deleted it.
2. Recreated the website with new id and mapping etc.

Now every time I type http://www.sweetsorella.com I get the “This site is no longer available”

I can’t find anything in the database that is stopping it

Any ideas ???? How to fix!!!!

Thanks In Advance!!