Tag: sp_adddistributiondb

How to run sp_browsereplcmds on a Distribution db backup

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting June 22, 2011

From time to time we need to restore a customer’s Distribution database to a secondary server or to a lab server for testing. When you restore a distribution database it will not be configured to execute Replication commands such as sp_browsereplcmds. However, there is a simple solution. You can execute the command below to configure
Read More »

Walkthrough setting up SQL Replication Distributor using TSQL commands

Chris Skorlinski [MSFT] Try This February 6, 2010

The scripts below and the video capture walkthrough setting up a Microsoft SQL Server Replication Distributor using SQL commands. As discussed in previous posting, the Distributor is a key role in Replication. It serves as a “cache” holding transactions for Transactional Replication and history tracking for all types of Replication. I’ve highlighted some of the
Read More »