Upgraded to Azure Storage Emulator 3.2, where have all my tables gone?

 | #StorageEmulator#Azure

In an attempt to solve a 400 error accessing tables on the Azure Storage Emulator 3.0 today, I upgraded to 3.2 using the Web Platform Installer. This resulted in a kind of good news, bad news situation. Good - The error stopped happening.

Bad - Where the f**k have all my tables gone!

I’ll be buggered if I’m recreating and repopulating them all so I went hunting. I managed to find the emulator database is in C:\Users<username>. In that directory you’ll find mdf files called WAStorageEmulatorDbXX.mdf where XX is the version number. I had ones ending in 22, 30, 32. Each will be accompanied by a _log file.

I loaded them up in Linqpad and the schemas looked the same, so for a punt I just renamed the files ending in 32 to something else and the renamed the files ending in 30 to 32.

Start up the emulator and everything is present again. That saved me a few hours!

About Alan Parr

Photo of Alan Parr

I am a .Net developer based in the Midlands in the UK, working on Azure, .Net Framework, .Net Core, and just generally playing around with anything that interests me. I play snooker (badly), archery (acceptably) and am a recovering Windows Phone user.