SQL Azure unexpected database deletion/recreation

Question

• For some reason, SQL Azure deleted and recreated our database
• The _MigrationHistory table was created in the process, registering a starting point to test the model against for future migrations

Here are our Questions

• Who / What triggered the database deletion / recreation?
• How could EF re-seed our sample data since Application_Start hasSystem.Data.Entity.Database.SetInitializer<Entities>(null);?

---

EDIT: Looking at what could've gone wrong, we noticed one thing we didn't respect in this SQL Azuretutorial: we didn't remove PersistSecurityInfo from our SQL Azure Entity database connection string after the database was created. Can't see why on Earth it could have caused the problem, but still worth mentioning...

Thanks for the help

Answer 1

Hi gdupuy,

I would like to involve someone familiar with this issue to have a look, and give an update later. Thanks for your understanding.

---

Stephanie Lv

TechNet Community Support

Answer 2

Can you help me understand what makes you think SQL Azure deleted and recreated your database?  Off the top of my head, I cannot think of a technically feasible scenario where this could have happened.