Hi,
We have an SQL server (lets call it FTANT001) and a
datatbase (lets say LETS30). I want to replicate the
database in the same server under the name LETS30_Repl.
Naturally the publisher, distributer and subscriber is the
same server FTANT001. I am susing a 'snapshot agent' to
replicate the database. I have successfully created the
publication (named as LETS30_Article). I have set up the
snapshot to be taken everyday at 7:00am. My problem is the
distribution agent status always shows as 'Never started'.
What could be the problem. Thanks in advance.
Cheers,
Sabuj
Sabuj,
what is the distribution agent's schedule? My guess is that it hasn't
matched its schedule time yet. Try running it manually to check that
everything is OK.
HTH,
Paul Ibison
Thursday, March 22, 2012
Data replication issues
Labels:
adatatbase,
call,
database,
ftant001,
lets30,
microsoft,
mysql,
oracle,
replicate,
replication,
server,
sql,
thedatabase
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment