At my work, I had to overwrite a MSSQL database while in production. The goal was to replace the existing database by one with a new structure.

I tried first the easy way, right clicking on it and trying to take it off line using the menu of Microsoft.

Unfortunately, that didn’t do anything, complaining that several users were accessing it. Of course, trying to restore it directly gave the same message.

I couldn’t find a way to successfully force it through the interface.
Continue reading →