Pull replication errors... -- sql server replication

Matt
6/29/2005 10:48:10 AM

Hi,

the idea is to setup an offsite backup of our single sql server, have
created a publication on the MASTER server, and pulled it to the offsite
server using FTP, downloaded snapshot, replicated transactions, all appeared
to work, generated schema, but the frontend database app didnt run, loads of
various errors showing up.

decided to restore the database from disk to the backup server, to check the
app is working fine, which it now is, so all i need to do is replicated the
changes in the tables on the master server to the offsite server, only needs
to be one-way, the offsite is only for backup read only....changed the
publication to tables only, re-created snapshot and now get errors saying...

Cannot update identity column. The step failed

help please on solution or other ways to achive this.

Hilary Cotter
6/29/2005 9:12:46 PM

comment the identity column update in the update proc.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Pull replication errors...