Does SQL Server on Azure VM allow for database to be put into SINGLE USER MODE?

Question

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.

Answer 1

@TheFellowship
I understand you wish to know if single user mode is possible when using SQL Server on Azure VM. The full features of SQL Server are available and this feature is as well.

-------------------------------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

As stated before from deherman:

The SQL Server installed on an Azure virtual machine is totally the same SQL server as you (your client) is using on-premise.
And as long it is just one VM with that SQL Server (standalone) and nothing different... like a FCI or AOAG then "Single User mode" for a database is present and should work as your client is used to on-premise.

IF not, pleae come back with a screenshot of that error message and an explanation.

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.