samedi 7 novembre 2009

Can’t Enable Service Broker On MSDB !

After restoring MSDB database to a different server, you may experience a problem configuring Database Mail feature due to the fact that Service Broker is not enabled on MSDB database and you will not be able to enable it.
Resolution :
to resolve this issue you have to create a new broker by executing the script below :
ALTER DATABASE [MSDB] SET NEW_BROKER WITH ROLLBACK IMMEDIATE
Go
ALTER DATABASE [MSDB] SET NEW_BROKER
Go
ALTER DATABASE [MSDB] SET ENABLE_BROKER
Go

Aucun commentaire:

Enregistrer un commentaire