BizTalk数据库丢失，不知道该怎么做 [英] BizTalk Databases Missing, Not sure what to do
问题描述
我正在测试我的代码更改，这意味着在Biztalk中取消部署/重新部署应用程序，然后所有BizTalk数据库都消失了（BAMAcrhive，BAMPrimaryImport，BiztalkDTADb，BizTalkMgmtDb，BizTalkMsgBoxDb，BizTalkRulEngineDb，BTAHL7） 。这是我的测试
环境但是，我没有这些数据库的任何备份（是的，我已经吸取了教训）。
I was testing my code changes, meaning undeploying/redeploying applications in Biztalk and then all of the BizTalk databases disappeared (BAMAcrhive, BAMPrimaryImport, BiztalkDTADb, BizTalkMgmtDb, BizTalkMsgBoxDb, BizTalkRulEngineDb, BTAHL7). This is my test environment however, i did not have any backups of these databases (yes i have learned my lesson).
我试过恢复来自另一个测试环境的数据库，然后更新服务器名称以及表中没有的内容。我尝试在控制台中停止/删除一些应用程序但是我收到更多错误。
I tried restoring databases from another test environment and then updating the server names and what not within the tables. I tried stopping/deleting some applications in the console but I get more errors that come up.
我假设已部署的应用程序的GUID / Keys TESTSERVER1和TESTSERVER2不同，因此不能正确删除。
I am assuming that the GUIDs/Keys of the deployed applications in TESTSERVER1 and TESTSERVER2 are different therefore it won't delete properly.
我目前收到此错误"地图'XXXXX'引用的模式已被删除。 BizTalk Server组配置的本地缓存版本已过期。在进行进一步更改之前，必须刷新BizTalk Server组配置。
（Microsoft.BizTalk.Administration.SnapIn）"。
I am currently getting this error"Schema referenced by Map 'XXXXX' has been deleted. The local, cached version of the BizTalk Server group configuration is out of date. You must refresh the BizTalk Server group configuration before making further changes. (Microsoft.BizTalk.Administration.SnapIn)".
当我尝试在控制台中刷新BizTalk组时，我得到了上述内容错误以及"应用程序不存在"
When I try to refresh the BizTalk Group in the console, i get the above error as well as "The application does not exist"
我试图截断由这些数据组成的表，但有太多的引用要经过麻烦。
I tried truncating the tables that consisted of this data but there are too many references to go through the trouble.
我还尝试恢复SSO密钥。更新的服务（Biztalk，SSO等）。当我尝试启动BizTalk服务BizTalk组：BizTalkServerApplication。它说服务已经开始和停止。
I have also tried to restore the SSO key. Updated services (Biztalk, SSO, and a few more). When i try to start the BizTalk Service BizTalk Group: BizTalkServerApplication. It says the service has started and stopped.
所以有几个问题：
So a few questions:
-
应该怎样我做？我希望重新安装BizTalk是最后的选择。
-
What should i do? I hope a re-installation of BizTalk is last resort.
数据库是如何首先消失的，取消部署脚本与数据库无关，只有应用程序
How did the databases disappear in the first place, the undeployment scripts have nothing to do with the databases, only applications
很抱歉，如果解决方案很明显，我绝不是BizTalk Developer。在星期五晚上只是一个有压力的初级BI开发人员。
Sorry if the solution is obvious, I am by no means a BizTalk Developer. Just a stressed junior BI developer on a friday night.
推荐答案
首先，三重检查您是否正在连接到正确的SQL实例。
First, triple check you are connecting to the right SQL Instance.
除此之外，您还需要取消配置/配置。 这不是什么大不了的事。 实际上，您可能花费更多时间来尝试修复从一开始就重新配置的情况。 :(）
Beyond that, unconfigure/configure is all you really need to do. It's not that big a deal. Realistically, you've probably spend more time trying to fix the situation that it would have taken to reconfig from the start. :()
这篇关于BizTalk数据库丢失，不知道该怎么做的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
