I'm setting up transactional replication with updatable subscriptions on Sql Server 2005. I setup the database with a backup, and haven't changed the schema or even changed the data since making the backup. I'm getting the following error in my job history:
Error 207: invalid column name 'msrepl_tran_version'
What is causing the problem?
From serverfault
ristonj
-
Found the answer, but not via Google directly. Transactional publication adds a column named "msrepl_tran_version" to each table in the database. I took the backup before setting up the replication, so the local copy did not have the msrepl_tran_version column. Restoring a more recent backup solved the problem.
From ristonj
0 comments:
Post a Comment