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)
 Failing to move object and Data

Author  Topic 

majolamp
Starting Member

15 Posts

Posted - 2008-03-11 : 04:28:57
Hi All

Just created replication from sql server 2005 (Discributor and Publisher) on the same server and my subscriber is sql2000 database.

Everything was created successfully but on the sql 200 DB I only see MSreplication_subscription,Mssubscription_agent and Mssubscription_properties.

all the bcp file are in a shared folder.

I've been checking I cann't see what could be the problem

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-11 : 09:09:10
Can you explain clearly what the problem was in subscriber?
Go to Top of Page

majolamp
Starting Member

15 Posts

Posted - 2008-03-11 : 10:42:21
quote:
Originally posted by sodeep

Can you explain clearly what the problem was in subscriber?




There are no tables in the and as a result there is no data. but bcp files have been created by replication on the shared unc folder.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-11 : 10:47:15
Did you check Replication monitor? Check snapshot agent status as well.
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-03-11 : 11:49:36
Looks like your distribution agent hasn't run.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-11 : 23:01:27
How did you set snapshot when configure replication?
Go to Top of Page
   

- Advertisement -