Restore & Replication Question

I think I have seen this question posted before, and I apologize if I am being redundant.
On a test server I 'refresh' the data in a database by restoring it from a production database. The test database that I am refreshing replicates to another database on the same server.
What is the best method for maintaining the replication setting of the test database?
Do I need to drop the replication, do the restore, then set replication back up from scratch?
If there is a scripting method, is it just a matter of right clicking on the publication and selecting generate sql script?
Thanx!
JLS,
if you are restoring a backup of a database which doesn't have the
replication settings on top of your test system, then you'll need to
recreate the publications (from the scripted publications on the test
system) and then reinitialize your subscribers.
HTH,
Paul Ibison
|||Redo the publication - Ok, Thanx!
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OSk2ctCaEHA.3244@.TK2MSFTNGP12.phx.gbl...
> JLS,
> if you are restoring a backup of a database which doesn't have the
> replication settings on top of your test system, then you'll need to
> recreate the publications (from the scripted publications on the test
> system) and then reinitialize your subscribers.
> HTH,
> Paul Ibison
>