Tag Archives: Transactional replication

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

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