Posted by David Gray on 11/15/06 13:47

Hi all,

SQL server 2000 on Windows 2003.

This is in test at the moment whilst I get to grips with replication.

I have a publication which contains numerous tables as published
articles. I'm
not ready to switch on the transacation transfer of data so have been
doing
snapshots when required. I'm now getting erros from the snapshot agent
for a
tables which don't exist in the publisher.

The process could not bulk copy out of table
'[dbo].[SYNC_XPS2SQL-BAP-Data_DESPATCH_AREA_METHOD]'.

I/O error while writing BCP data-file

The table DESPATCH_AREA_METHOD exists in both publisher and subscriber
and XPS2SQL-BAP-Data
is the name of the publication. The metadata is the same at both ends.

Anyone got any ideas?

Thanks in advance
Dave

• Next in forum: Re: Converting a file into multiple tables
• Prev in forum: Re: I want to revert back to original state of database before i performed restore database
• Thread view: snapshot agent failure on unknown table

[Reply to this message]