如果无法访问Azure SQL数据库，该如何终止它? [英] How do I kill connections to Azure SQL database if I can't access it?
问题描述
今天，我们迁移到了AzureSQL V12.今晚我的网站离线，原因是持续出现以下消息:
Today we migrated to AzureSQL V12. Tonight my site is offline, because of a persistent issue with the following message:
资源ID:3.数据库的LoginLimit限制为90，并且已达到.请参阅" http://go.microsoft.com/fwlink/?LinkId=267637 ' 寻求帮助. (Microsoft SQL Server，错误:10928)
Resource ID : 3. The LoginLimit limit for the database is 90 and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance. (Microsoft SQL Server, Error: 10928)
我尝试了以下操作:
- 重新启动我的网站的服务器(也尝试了iisreset并重新启动该Web应用程序)
- 删除了Azure门户中的所有IP筛选器(包括来自Azure服务的访问权限)
- 在Azure中升级到下一层(它停留在进行中"且未更改，因此我认为连接阻止了升级)
我无法通过SSMS连接到我的数据库.我收到相同的错误消息.现在已经持续了几个小时，而且我的网站完全处于离线状态，但是登录次数没有改变.
I can't connect to my database via SSMS. I get the same error message. This has lasted for hours now, and my site is completely offline, yet the number of logins is not changing.
我需要某种方法来断开这些连接中的某些连接，以便我继续进行诊断，可能是问题所在.
I need some way to disconnect some of these connections so I can get on and diagnose what the issue might be.
推荐答案
此问题是由于Azure自动备份未能正确结束会话引起的.其他答案均无济于事，因为它们都要求您能够连接到数据库，而我无法做到这一点.我最终在电话上与Microsoft支持通话了几个小时，在此期间，由于同样的原因，他们也无法连接到数据库.
This issue was caused by Azure automated backups failing to end sessions correctly. None of the other answers worked as they all require you to be able to connect to the database, and I was unable to do this. I ended up speaking on the phone to Microsoft Support for some hours, during which they were also unable to connect to the database for the same reason.
从最终开始，解决方案是将数据库迁移到新节点，Azure用户无法执行此操作，因此，如果遇到此级别的问题，实际上最好的(也是唯一的)操作是尽快联系Microsoft支持.
The resolution, from their end, was to migrate the database to a new node, which is not something that Azure users can do, so if you encounter this level of issue, really the best (and only) thing to do is to contact Microsoft support ASAP.
我确实建议先在这里尝试其他一些建议，但是由于无法建立任何连接，您会被卡住.
I do recommend trying out some of the other suggestions here first, but without the ability to make any connections you will be stuck.
由于这是在Azure上升级数据库的过程中发生的，因此，为了预防起见，我们实施了在升级数据库之前禁用自动备份的过程，并且该问题并未再次发生.
Because this occurred during the process of upgrading a database on Azure, we implemented a procedure of disabling automated backups before upgrading databases as a precaution, and the problem has not reoccurred for us.
这篇关于如果无法访问Azure SQL数据库，该如何终止它?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
