newbie: how-to start a transactionnal replication ?

Hi,
I'm newbie on replication, so :
I own 2 MSSQL server 2000 servers :
- server A owns many populated databases (biggest is hundreds of Gb)
- server B is fresh installed and have no databases
I would replicate the server A over the server B so :
- I configured server A as publisher and local distributor,
- I created publications for transactional replications for databases I
wish to replicate on server A
- I created empty datadates on server B and I created subscriptions on
corresponding databases on server A
- I created a privilegied account on my AD domain for the transaction
coordinator service that can log on both servers
The problem is I should get an initial image snapshot for my databases on
server A, but I don't know how to create them...
thanks for any support ;)
Eric Belhomme
Eric,
as you have publications and subscriptions set up, you should now be in a
position to run the snapshot and distribution agents to initialise the
subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Are you getting any error/status messages when you run your distribution
agent?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Eric Belhomme" <{rico}+no/spam@.ricospirit.net> wrote in message
news:Xns973FA26E2C75Eericbelhommefreefr@.212.27.42. 134...
> Hi,
> I'm newbie on replication, so :
> I own 2 MSSQL server 2000 servers :
> - server A owns many populated databases (biggest is hundreds of Gb)
> - server B is fresh installed and have no databases
> I would replicate the server A over the server B so :
> - I configured server A as publisher and local distributor,
> - I created publications for transactional replications for databases I
> wish to replicate on server A
> - I created empty datadates on server B and I created subscriptions on
> corresponding databases on server A
> - I created a privilegied account on my AD domain for the transaction
> coordinator service that can log on both servers
> The problem is I should get an initial image snapshot for my databases on
> server A, but I don't know how to create them...
> thanks for any support ;)
> --
> Eric Belhomme
>
|||Look under your SQL Server Agent. There should be jobs for snapshot and
distribution, if everything setup correctly.
Now open the Replication Monitor and look to see if the Snapshot Agent has
run. If it has, then check to see if the distribution agent has applied
changes. If one or the other hasn't run, then right click on them and start
them.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Eric Belhomme" <{rico}+no/spam@.ricospirit.net> wrote in message
news:Xns973FA26E2C75Eericbelhommefreefr@.212.27.42. 134...
> Hi,
> I'm newbie on replication, so :
> I own 2 MSSQL server 2000 servers :
> - server A owns many populated databases (biggest is hundreds of Gb)
> - server B is fresh installed and have no databases
> I would replicate the server A over the server B so :
> - I configured server A as publisher and local distributor,
> - I created publications for transactional replications for databases I
> wish to replicate on server A
> - I created empty datadates on server B and I created subscriptions on
> corresponding databases on server A
> - I created a privilegied account on my AD domain for the transaction
> coordinator service that can log on both servers
> The problem is I should get an initial image snapshot for my databases on
> server A, but I don't know how to create them...
> thanks for any support ;)
> --
> Eric Belhomme
>
|||"Michael Hotek" <mike@.solidqualitylearning.com> wrote in
news:#nJ5w#IEGHA.472@.TK2MSFTNGP12.phx.gbl:

> Now open the Replication Monitor and look to see if the Snapshot Agent
> has run. If it has, then check to see if the distribution agent has
> applied changes. If one or the other hasn't run, then right click on
> them and start them.
>
thanks all for your answers
It looks better now, but I'm still in trouble : on the "replication
monitor", I get red crosses on the "Editors" branch and on all my published
databases, except one.
But I can select replicated datas on my server B, and datas seems to be up
to date !
I don't know why I get these crosses, what they mean (I can't find any
errors and reports looks ok) and how to discard them...
Eric Belhomme
|||Eric,
if everything is running correctly, it may be that this error icon purely
relates to out-of-date info. The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)