Hi,

Is there any command or procedure to backup a publication
set up ? Sometime I must delete a subscription and
articles(tables) of a publication so that I can drop that
(article) table and recreate it.
I do the drop on the initial snapshot for bulk insert when
some error occur on my replication.

Thank you,
Eduardo.

Report this post to a moderator

You can script out both publisher and subscriber. Right click on publication
folder and choose "generate sql script..."


Richard

"Eduardo" <eakinto@buscape.com.br> wrote in message
news:693f7309.0211130313.5765c106@posting.google.com...
> Hi,
>
> Is there any command or procedure to backup a publication
> set up ? Sometime I must delete a subscription and
> articles(tables) of a publication so that I can drop that
> (article) table and recreate it.
> I do the drop on the initial snapshot for bulk insert when
> some error occur on my replication.
>
> Thank you,
> Eduardo.

Report this post to a moderator