Replication

I have Publisher, distributer and subscriber which is SQL 2000. I have built
a new Subscriber with Win2003 and SQL 2005 and wanted to replace the old
subscriber which was SQL 2000. I would like to avoid doing a snapshot to the
new server.
My question can I tell SQL 2000 to DO not do a snapshot as long as the two
Databases are in sync or do I have to reinitialize the snapshot.
The old (Subscriber) name and the New (Subscriber) name are not the same
Here is my plan
1-Verify all transactions have been distributed before deleting replication
Lunch a SQL Server Enterprise manager on OWSQL Server
Expand SQL Server Agent folder, and expand Jobs folder
Right -Click Distribution Clean up Job: Distribution job,
click start the job
Wait for completion.
To Verify all transaction have been distributed to SYMPHONYPROD, Execute the
following T-SQL statements using query analyzer in the distribution Database
and the result should return 0.
Select count (*) AS MSrepl_commands FROM Distribution WITH (nolock)
Select count (*) AS MSrepl_transactios from Distribution WITH (nolock)
2-Delete Publications in OWSQL
Delete all five OWSQL related publications as follows:
Launch a SQQL Server Enterprise Manger on OWSQL Server
Expand the replication folder and then expand publications folder.
Delete
JDESYM: JDE_production
JDESYM_Archive:JDE_Production
JDESYM_F4211: JDE_production
JDESYM_F554101B: JDE_production
JDESYM_Others: JDE_production
3-Recreate the Publications point to the new Subscriber and start the
distribution agent
Do a no-sync subscription.
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
<msnews.microsoft.com> wrote in message
news:uq9rORgqHHA.1204@.TK2MSFTNGP04.phx.gbl...
>I have Publisher, distributer and subscriber which is SQL 2000. I have
>built a new Subscriber with Win2003 and SQL 2005 and wanted to replace the
>old subscriber which was SQL 2000. I would like to avoid doing a snapshot
>to the new server.
> My question can I tell SQL 2000 to DO not do a snapshot as long as the two
> Databases are in sync or do I have to reinitialize the snapshot.
> The old (Subscriber) name and the New (Subscriber) name are not the same
>
> Here is my plan
>
> 1-Verify all transactions have been distributed before deleting
> replication
> Lunch a SQL Server Enterprise manager on OWSQL Server
> Expand SQL Server Agent folder, and expand Jobs folder
> Right -Click Distribution Clean up Job: Distribution job,
> click start the job
> Wait for completion.
> To Verify all transaction have been distributed to SYMPHONYPROD, Execute
> the following T-SQL statements using query analyzer in the distribution
> Database and the result should return 0.
> Select count (*) AS MSrepl_commands FROM Distribution WITH (nolock)
> Select count (*) AS MSrepl_transactios from Distribution WITH (nolock)
>
> 2-Delete Publications in OWSQL
> Delete all five OWSQL related publications as follows:
> Launch a SQQL Server Enterprise Manger on OWSQL Server
> Expand the replication folder and then expand publications folder.
> Delete
> JDESYM: JDE_production
> JDESYM_Archive:JDE_Production
> JDESYM_F4211: JDE_production
> JDESYM_F554101B: JDE_production
> JDESYM_Others: JDE_production
>
>
> 3-Recreate the Publications point to the new Subscriber and start the
> distribution agent
>