If I enable activation on my queue, as soon as a message arrives the queue
becomes disabled. I understand that this is usually due to an error
occurring in the activation SP. However, if I disable activation, let a
message arrive and then run the same SP manually using the same ...

We have recently discovered and issue where we had
over 15,000,000 rows in sys.conversation_endpoints.  This records all have a
status of 'closed', but they are not being removed from the table.  It is my
understanding that if the conversation is 'closed', these rows should be

My tests indicate that once i turn broker_enabled property off, backup the
database, restore, then set the broker_enabled property on, backup the
database, restore, it still remains turned off. Is this the expected behavior
or that i am lost here.