PROBLEM:
The SQL broker queue is constantly climbing and I regularly see the following error in the SQL server logs.
An exception occurred while enqueuring a message in the target queue. Error: 33009, State:3. The database owner SID recorded in the master database differs from the database owner SID recorded in database 'ksubscribers'.
Error: 28005, Severity:16, State:2.
CAUSE:
The owner of the database is not the SA account. This can often times happen when the database is restored with an account that is not the SA account.
SOLUTION:
Run the following command to find the owner of the ksubscribers database.
Run the following command in SQL management studio.
ALTER AUTHORIZATION ON DATABASE:: [ksubscribers] TO [SA]
This will change the owner of the database to the sa account.