启用 SQL Server Broker 耗时过长 [英] Enable SQL Server Broker taking too long

问题描述

我有一个 Microsoft SQL Server 2005，我尝试使用那些 T-SQL 为我的数据库启用 Broker:

I have a Microsoft SQL server 2005 and I tried to enable Broker for my database with those T-SQL:

 SELECT name, is_broker_enabled FROM sys.databases 
 -- checking its status 0 in my case
 ALTER DATABASE myDatabase SET ENABLE_BROKER

Alter Database 需要很长时间来处理.现在已经过了半个小时，它仍在运行.不知道是在等别的还是我得先清理一下，比如删除service broker下的所有消息、合同、队列和服务?

The Alter Database takes long time to process. It is now over half hour and it is still running. Not sure if it is waiting for something else or I have to clean up anything first, such as delete all the messages, contract, queue and services under service broker?

推荐答案

http://rusanu.com/2006/01/30/how-long-should-i-expect-alter-databse-set-enable_broker-to-run/

alter database [<dbname>] set enable_broker with rollback immediate;

这篇关于启用 SQL Server Broker 耗时过长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！