it works for the transactional replication. This solution has not been tested for the snapshot, merge, and P2P replications.

• This reply was modified 3 years, 11 months ago by  WAL.
• This reply was modified 3 years, 11 months ago by  WAL.
• This reply was modified 3 years, 11 months ago by  WAL.

Awesome! The best IT consultant.

I make sure that databases are available to the business 24/7. It is the main point. Other crucial point is automating administrative tasks like backups, replication, etc.

Edward,
you are lucky to have space on I drive. What would you do if there is no space for the second filegroup?

These routes look ok unless broker_instance guid do not match. Do they match?

Can you try to add binding on the source and rerun ssbdiagnostic:

CREATE REMOTE SERVICE BINDING SourceBinding

...

Jefferson Elias (2/22/2016)

---

I followed exactly the script you provided.

As you suggest, there might be a problem in contacting the target service.

The configuration is as follows :

192.168.98.xx for the source and...

Jefferson Elias (2/17/2016)

---

Hi,

sorry for the delay.. I had to do some other tasks before coming back to this...

As I followed the scripts attached to the article, there is a...

It looks like route is missing or invalid on the Source db.

Do you have firewall on 4022 port? Have you created SampleServiceTarget service already?

Jefferson Elias (2/10/2016)

---

After reading everything and I tried to run from attached scripts, I can't manage to get it work.

I'm trying to run Service Broker on two separate servers. The...

Jefferson Elias (2/10/2016)

---

Hi, thanks for this article.

While running the code you provided, there is a little syntax error at

CREATE ENDPOINT ServiceBrokerEndpoint AUTHORIZATION $(LoginName)

STATE= STARTED AS TCP

( LISTENER_PORT=4022, ...

Data compression is Enterprise Edition feature. There is a nice article written by MS:

https://technet.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

"The data compression feature in the Microsoft® SQL Server® 2008 database software can help reduce...

Unfortunately this sp(sp_SQLskills_ConvertTraceToExtendedEvents) does not work on SQL Server 2008, because sys.trace_xe_event_map system table was introduced later in v11. 🙂