We recently need to find all the difference in data between 2 SQL Servers each with 300 SQL replicated tables. To find the differences, we were planning on using the TableDiff utility included with SQL 2005 which is a command line tool designed to provide TSQL needed to manually sync two table in two different
Read More »
SQL Server sp_showpendingchanges is used to determine how many changes need to be moved to a subscriber or uploaded to a publisher. You can use these steps to “roll your own” and pull similar data. To tackle this problem from the meta data can be a bit daunting, but there are some ways to get
Read More »
Sateesh Yele | Microsoft SQL Server Support How to initialize the subscriber from backup Create the publication using user interface Replication Wizard. Under subscription options for the publication, set “allow initialization from backup files” to true Create a new full backup of the publisher database. If you have existing full backup of the publisher database,
Read More »
Updated post on The process could not execute ‘sp_replcmds’
Have you seen errors like these below when attempting to run SQL Replication Wizard or start a SQL Agent job? TITLE: Microsoft SQL Server Management Studio —————————— SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022) SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent
Read More »