Category Archives: Replication

Add a table to an Existing Transactional Replication using T-SQL and Generate Snapshot using T-SQL

Replace the PublishedDB with your published database and TableName with the table name you want to replicate The next step is to start the snapshot agent to pick up the new tables added to replication and replicate across to Subscriber … Continue reading

Posted in Replication, SQL Server, T-SQL Scripts, Transactional Replication, Tricks | Leave a comment

Database Migration Automated

Its been a while since I posted anything here… Phew… Finishing a very tight deadline and critical Database Migration Project today. I have done myself some justification by automating the Database Migration work, that would otherwise require me to perform … Continue reading

Posted in .bat scripts, LogShipping, Replication, RoboCopy, Setup, SQL Server, SSIS, T-SQL Scripts, Transactional Replication, upgrade | Tagged , , , | Leave a comment

Two main tables in a distribution database to facilitate replication

Somebody asked me this question: “What are the two main tables in a distribution database when you configure replication“ The two main tables in a distribution database to facilitate replication are those that contain the information on where to start … Continue reading

Posted in Replication, SQL Server, Tricks | Tagged | Leave a comment

Exception Message: The snapshot could not be generated because the publisher is inactive.

Issue:- Snapshot Agent throw errors while setting up transactional replication. Replication scripted out from another server and applied with the new publisher, distributor and subscriber details. Message Microsoft (R) SQL Server Snapshot Agent [Assembly Version = 10.0.0.0, File Version = … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged | Leave a comment

Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214

Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214 Issue:- Unable to enable a database to publish running the t-sql exec sp_replicationdboption ‘<dbname>’,’Publish’,’true’ Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214 The specified ‘@server’ is invalid (valid … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged | 2 Comments

System.Data.SqlClient.SqlException: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable Subscriptions: Rolling back transaction

System.Data.SqlClient.SqlException: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable Subscriptions: Rolling back transaction Resolution:- Add a link to the publisher server on the subscriber database for the updatable subscription (transactional replication). … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged , , , | Leave a comment