reinstall of the subscriber server

We are using SQL 2K std with s4 and are using Push subscription method.
We need to upgrade some hardware in the subscriber server which will require
us to do a total reinstall of the OS and SQL server software. Since we are
using push subscription, most of the replication settings are on the
publishing server. When we do the server upgrade, I will stop the
distribution agent so it won't do any transfer until the server is up. I
like to know if I back up the subscriber database and restore it on the same
upgraded server. Will the replication work like as usual? Are there any
steps I need to consider?
wingman
As long as the server name, database name, and IP address are identical this
will work.
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
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:9E5E069D-1FBD-4A37-8DA3-C09BCCE53F8E@.microsoft.com...
> We are using SQL 2K std with s4 and are using Push subscription method.
> We need to upgrade some hardware in the subscriber server which will
> require
> us to do a total reinstall of the OS and SQL server software. Since we
> are
> using push subscription, most of the replication settings are on the
> publishing server. When we do the server upgrade, I will stop the
> distribution agent so it won't do any transfer until the server is up. I
> like to know if I back up the subscriber database and restore it on the
> same
> upgraded server. Will the replication work like as usual? Are there any
> steps I need to consider?
> wingman
|||As long as the distribution agent was stopped and you restore the database
ensuring that you keep replication settings, then you should be able to
simply resume the distribution agent and it will catch up. In the event
that it fails for some reason, you will have to reinitialize it.
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:9E5E069D-1FBD-4A37-8DA3-C09BCCE53F8E@.microsoft.com...
> We are using SQL 2K std with s4 and are using Push subscription method.
> We need to upgrade some hardware in the subscriber server which will
> require
> us to do a total reinstall of the OS and SQL server software. Since we
> are
> using push subscription, most of the replication settings are on the
> publishing server. When we do the server upgrade, I will stop the
> distribution agent so it won't do any transfer until the server is up. I
> like to know if I back up the subscriber database and restore it on the
> same
> upgraded server. Will the replication work like as usual? Are there any
> steps I need to consider?
> wingman
|||Z,
Thanks for the suggestion. I need some clarification of your statement
"ensuring that you keep replication settiings". Since we are using the
'Push' subscription, as far as I know, all replication settings are in the
publishing computer. Are there other settings in the subscriber server that
I should know about? Also, if I restore the subscriber database from the
backup, should the settings (if any) be restored as well?
wingman
"Z" wrote:

> As long as the distribution agent was stopped and you restore the database
> ensuring that you keep replication settings, then you should be able to
> simply resume the distribution agent and it will catch up. In the event
> that it fails for some reason, you will have to reinitialize it.
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:9E5E069D-1FBD-4A37-8DA3-C09BCCE53F8E@.microsoft.com...
>
>
|||Thanks.
One quick follow-up question. I understand the idea of the purpose of the
log reader agent and I don't need to shut it down for what I am planning to
do. I noticed that if I want to delete a subscriber database, I need to shut
the log reader agent down because the log reader agent is running a command
"rplcmds' and is connected to the subscriber database. First of all, is my
finding correct? Secondly, can you explain what this command does?
wingman
"Hilary Cotter" wrote:

> As long as the server name, database name, and IP address are identical this
> will work.
> --
> 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
> "Wingman" <Wingman@.discussions.microsoft.com> wrote in message
> news:9E5E069D-1FBD-4A37-8DA3-C09BCCE53F8E@.microsoft.com...
>
>
|||You don't need to shut down the log reader to delete the subscription
database, rather you need to shut down the distribution agent. The log
reader is connected to the publication database and the distribution
database. I am unfamiliar with the rplcmds command.
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
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:1F21FF5C-083A-43CB-9EA6-59EC9A103AA2@.microsoft.com...[vbcol=seagreen]
> Thanks.
> One quick follow-up question. I understand the idea of the purpose of the
> log reader agent and I don't need to shut it down for what I am planning
> to
> do. I noticed that if I want to delete a subscriber database, I need to
> shut
> the log reader agent down because the log reader agent is running a
> command
> "rplcmds' and is connected to the subscriber database. First of all, is
> my
> finding correct? Secondly, can you explain what this command does?
> wingman
> "Hilary Cotter" wrote:

Reinitilize subscribtions

I have trans replication and i want every sunday to make complete snapshot -
push replication. If I was able to make some command with query analyzer to
reinitilize subscribtions it would be great!
Thanks in advance!I believe you can change the snapshot agent schedule to do once on every
Sunday.
richard
"Dalibor Cvijetinovic" <dalibor@.ice.si> wrote in message
news:uIdVvwK5DHA.488@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I have trans replication and i want every sunday to make complete

---

snapshot -

quote:

---

> push replication. If I was able to make some command with query analyzer

---

to

quote:

---

> reinitilize subscribtions it would be great!
> Thanks in advance!
>

---

Reinitilize subscribtions

I have trans replication and i want every sunday to make complete snapshot -
push replication. If I was able to make some command with query analyzer to
reinitilize subscribtions it would be great!
Thanks in advance!I believe you can change the snapshot agent schedule to do once on every
Sunday.
richard
"Dalibor Cvijetinovic" <dalibor@.ice.si> wrote in message
news:uIdVvwK5DHA.488@.TK2MSFTNGP12.phx.gbl...
> I have trans replication and i want every sunday to make complete
snapshot -
> push replication. If I was able to make some command with query analyzer
to
> reinitilize subscribtions it would be great!
> Thanks in advance!
>

Reinitializing Push subscription after it expired in Transactional Replication

I am using SQL 2000. How can I get my transactional replication reinitialized after it has failed with several attempts.

I know one way of doing it through enterprise manager and specifying the subscription to reinitialize. But this will apply the snapshot and will take long time.

Is there a fast way of doing it?

-Nipul

A reinitialize requires reapplying the snapshot. Can you be more clear what you're trying to accomplish? I think what you want to do is just restart the distribution agent, does this work?