To cut it short, the site collection still remains in Central Admin while the content database is deleted. I used powershell, but I get cannot open database "db" after requested by the login. Login failed.
Login is just fine, but the database is not there and I cannot do a restore of the deleted site.
So, I can I clean this faulty site collection without having the content database? I have taken a test content database from my dev machine and deployed to the other farm. Now, I would like to attach this content database with the existing site collection which does not have a content database. Is that possible and how?