Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Trans Replication via ftp

Author  Topic 

TiGGi
Starting Member

29 Posts

Posted - 2009-09-04 : 00:07:13
Hi all,
Bit of a problem with replication I am setting up and here's what I've got so far:
Both server run MS SQL 2005 Standard
I've created Publication with ability for subscriber to d/l snapshot via ftp.
- defined the ftp server info
- snapshot writes to ftp default folder (c:\SQLReplication)
- when publication runs it creates folders inside the root so it ends up with something like:
c:\SQLReplication\SQLServer_TestDB\20090903160715\snapshot.cab

On subscriber I was able to connect to publication just fine, synchronization runs and completes without errors but I got no data in the subscribers database?
Do I need to manually download the snapshot.cab or something?
   

- Advertisement -