Replication Monitor
- From: "ansonee" <ansonee@xxxxxxxxx>
- Date: 8 Jul 2005 12:07:45 -0700
I'm experiencing some very odd behavior in Enterprise Manager.
I have a process that performs the following:
1.) Restores a published database from Server A onto Server B. The
databases
are identical and they are both published.
2.) I run a script that then deletes the subscriptions to the
publication on
Server B. I do this via SP_DROPSUBSCRIPTION.
3.) I run a script that then deletes the publication. I do this via
SP_DROPPUBLICATION.
4.) Deletes the distribution database.
5.) Deletes the old jobs.
6.) Creates the publication from pregenerated scripts.
7.) Adds the subscriber.
8.) Adds the subscription.
9.) Generates the snapshot and applies it.
What's happening is that I'm seeing the job name that's assigned to the
distribution job increment by 1 each time this process is run. Also,
I'm
seeing ten instances of the publication showing up in the tree view.
Everything appears to be rtunning just fine, transactions being
replicated,
etc. I'm just wondering is there something I'm missing in my steps.
Plus,
after two or three months of this, might not look so good having 90
publications showing up in the tree view.
Thanks!
.
- Follow-Ups:
- Re: Replication Monitor
- From: Simon Hayes
- Re: Replication Monitor
- Prev by Date: Re: Moving data for reporting
- Next by Date: Re: Log file size not reduce
- Previous by thread: use of 'index' as a field name
- Next by thread: Re: Replication Monitor
- Index(es):
Relevant Pages
|
