We have a client looking to move on site server hardware to a Azure VM. They run SQL Server and one of their instances requires SINGLE USER mode at times for some of its databases.
I have noticed that with Azure SQL Server you are not permitted to put a database into SINGLE USER mode because it is in a "mirrored or high availability environment" according to an error message I was given. So this option wouldn't work.
I had setup a sales meeting with a Azure rep, but he was less than helpful with discussing the details of the product. Wanted to bring in a few other people to answer those questions. I have emailed him no less than 3 times, with zero response.
So will SQL Server (standard) on a Azure VM allow for SINGLE USER MODE just like it was on a on-premise server?
Thank you in advance for any information you can provide.