Re: BCP error during DB Sync on Filtered Columns

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 13:48:18 -0500

the problem is because you have different schemas on your publisher and
subscriber.

You should recreate and redeploy your snapshot to fix this. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"misterkit(at)yahoo.com" <misterkit(at)yahoo.com@discussions.microsoft.com>
wrote in message news:847D3E50-44D7-4B37-9BE4-DDF54D379844@microsoft.com...
> Hi,
>
> I'm have a wonderful time configuring replication on a set of tables and
> need some help in diagnosing an error that is popping up.
>
> Currently, I am using the transactional model with queued updating.  I
have
> a set of tables that contain text columns, so during the publication build
I
> excluded these columns.
>
> I then took a backup of the database and restore it at the subscriber.
>
> When the DB's try to sync, I am getting the following error message on the
> tables that have filtered columns:
>
> 'The process could not bulk copy into table 'tablename'
>
> Unexpected EOF encountered in BCP data-file.
>
> SQL is creating the file behind the scenes when the snapshot occurs, so I
am
> not directly creating a format file for it to use.
>
> Any thoughts on how to fix this error?

Relevant Pages

  • Re: trans replication of large tables...
    ... Just because it is set to local admins doesn't mean that it can ... something as simple as a timeout during the application of the snapshot. ... subscriber, the subscription is created specifying that the subscriber ... > in the same publication - or if they are queried in the same procs they ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Delivery - Violation of PRIMARY KEY constraint
    ... which I have mentioned previously is that your filter is time-dependent. ... the set of rows that qualify your filter when the snapshot was ... you will get uniqueness violation ... destination table is created from scratch at the subscriber (meaning you ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication over FTP
    ... My publisher, when setting up the replication, ... The subscriber, a pull merge subscription, has all the ... > place over port 1433 except for the application of the snapshot which is ... >> Can I, when setting up the database, export all objects to the server. ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshots, Validation, Resynchronization with Merge Replicatio
    ... You should have your distribution database on your ... In your topology when you run the snapshot agent, ... What this means is that a subscriber has 14 days to sync at least ... NOw the question is how often do you have to run the snapshot. ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Delivery - Violation of PRIMARY KEY constraint
    ... The simplest explanation is that the filter you use for deleting data at the ... data delivered with the snapshot. ... publisher and at the subscriber. ... Delivering a snapshot is fundamentally a very disruptive process at the ...
    (microsoft.public.sqlserver.replication)