如何停止和启动SQL Azure数据库? [英] How do I stop and start a SQL Azure database?

问题描述

我正在运行一个基于Azure的站点，出于历史原因，该站点在两台服务器上使用两个数据库.我已经从静态数据源复制了数据，因此它们都驻留在同一服务器上.我相当确定我已经从实时代码中删除了对旧服务器的所有引用，并且确实Azure仪表板在上个月没有显示任何连接.但是要100％确定，在删除服务器之前，我想停止它并测试实时站点.如果有任何问题，我想重新开始.在SQL Server Management Studio中，这通常很简单，我可以在SQL Server Management Studio对象资源管理器中的服务器上单击鼠标右键，然后选择停止"，然后选择启动".但是，SQL Azure服务器的选项中未列出停止"和启动"，在Azure门户的管理页面上也看不到任何内容.

I am running an Azure based site that for historic reasons uses two databases on two servers. I have copied the data from the static data-source so that both reside on the same server. I am fairly sure I have removed all references to the old server from the live code, and indeed the Azure dashboard shows no connections over the last month. But to be 100% sure before I delete the server I would like to stop it and test the live site. If anything goes wrong I would then like to start it again. In SQL Server Management Studio this is usually straightforward, I can right-click on a server in the SQL Server Management Studio object explorer and select 'Stop' and then if needed 'Start'. However 'Stop' and 'Start' are not listed in the options for SQL Azure servers, nor is there anything I can see in the management pages on the Azure portal.

所以我的问题很简单-如何停止和启动SQL Azure数据库?

So my question is simple - how do I stop and start a SQL Azure database?

推荐答案

如Praggie所述，您无法停止/启动SQL Azure服务器. SQL Azure数据库位于共享主机上.该服务器上还有其他租户.您可以访问数据库，但不能访问相应的托管服务器.

as Praggie mentioned, you cannot stop/start the SQL Azure servers. A SQL Azure Database resides on a shared host. there are other tenants on that server. you have access to the database, but not to the corresponding hosting server.

您可以重命名数据库，如果有任何应用程序连接到数据库，则它们将失败.

you can rename the database and if there's any app connecting to it, then they'd fail.

这篇关于如何停止和启动SQL Azure数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！