0

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?

1 Answer 1

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .