title: Enabling broker after Restoring Sql Server DataBase
body: <p>I have DataBase with enabled Service Broker. Then I want to restore my database in program from backup of other database, but after restoring(I restore on existing database name), my method, whitch enables Service Broker, puts this error:</p>
  
  <pre><code>    Msg 9772, Level 16, State 1, Line 1
  The Service Broker in database "ServeDB2" cannot be enabled because there is already an enabled Service Broker with the same ID.
  Msg 5069, Level 16, State 1, Line 1
  ALTER DATABASE statement failed.
  </code></pre>
  
  <p>This is my method:</p>
  
  <pre><code>public void TurnOnBroker()
  {
      if (!this.database.BrokerEnabled)
      {
          this.server.KillAllProcesses(this.database.Name);
          this.database.BrokerEnabled = true;
          this.database.Alter();
          RefreshConnection();
      }
  }
  </code></pre>
  
  <p>What should i fix here?Any suggestions?</p>