创建后无法立即打开Azure SQL Server数据库 [英] Not able to open Azure SQL Server DB immidiately after the creation

问题描述

我正在尝试在Azure SQL Server中自动创建租户数据库. 数据库已创建/复制为

I am trying to automate the tenant DB creation in Azure SQL Server. DB has been created/copied as

CREATE DATABASE {0} AS COPY OF {1} ( SERVICE_OBJECTIVE = 'S2' )

立即将记录添加到同一表中的一个.错误提示为:

Immediately adding a record to one of the table in the same. Getting error as:

功能已完成(故障，Id = 1046eae2-c07a-4eee-9a1d-886e89ab5071) 发生ScriptHost错误 执行函数时发生异常:Functions.CreateTenant. .Net SqlClient数据提供程序:服务器'dbserver'上的数据库'tenant8'当前不可用.请稍后重试连接.如果问题仍然存在，请联系客户支持，并为他们提供会话跟踪ID"8AF58081-8F25-4B7F-83E3-63AFFC13C8CB". 执行函数时发生异常:Functions.CreateTenant 执行了'Functions.CreateTenant'(失败，ID = 1046eae2-c07a-4eee-9a1d-886e89ab5071) 功能出现错误.有关详细信息，请参见Azure WebJobs SDK仪表板.实例ID为'1046eae2-c07a-4eee-9a1d-886e89ab5071'

Function completed (Failure, Id=1046eae2-c07a-4eee-9a1d-886e89ab5071) A ScriptHost error has occurred Exception while executing function: Functions.CreateTenant. .Net SqlClient Data Provider: Database 'tenant8' on server 'dbserver' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '8AF58081-8F25-4B7F-83E3-63AFFC13C8CB'. Exception while executing function: Functions.CreateTenant Executed 'Functions.CreateTenant' (Failed, Id=1046eae2-c07a-4eee-9a1d-886e89ab5071) Function had errors. See Azure WebJobs SDK dashboard for details. Instance ID is '1046eae2-c07a-4eee-9a1d-886e89ab5071'

推荐答案

看着错误消息，您似乎正在尝试在配置和部署数据库tenant8之前插入数据.部署数据库需要几十秒到几分钟的时间.可以在以下博客帖子.请告知我们部署是否需要5分钟以上.

Looking at the error message, it seems that you are trying to insert data before the database tenant8 has been provisioned and deployed. Deploying a database takes any time between a few dozens seconds to a few minutes. A description of the steps involved in this operation can be found on this blog post by Steve Mark. Please let us know if the deployment takes more than 5 minutes.

这篇关于创建后无法立即打开Azure SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！