Re: newbie: how-to start a transactionnal replication ?
- From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Jan 2006 12:01:05 -0600
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@xxxxxxxxxxxxxx> wrote in message
news:Xns973FA26E2C75Eericbelhommefreefr@xxxxxxxxxxxxxxxx
> 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
>
>
.
- Follow-Ups:
- Re: newbie: how-to start a transactionnal replication ?
- From: Eric Belhomme
- Re: newbie: how-to start a transactionnal replication ?
- References:
- newbie: how-to start a transactionnal replication ?
- From: Eric Belhomme
- newbie: how-to start a transactionnal replication ?
- Prev by Date: Re: Transaction replication question
- Next by Date: Re: Application is closed during second synchronization
- Previous by thread: Re: newbie: how-to start a transactionnal replication ?
- Next by thread: Re: newbie: how-to start a transactionnal replication ?
- Index(es):
Relevant Pages
|
