2012年2月25日星期六

Disabling replication on existing databases

Hi,
we are adding new verisons of databases to out SQL Instance. we want to
disable existing databases replication, with out effecting production db
replication process.
i think if u use GUI, SQL Server will disable all the prublications? i am
not sure this is correct or wrong.
please advise me, the scripts which should execute, perform and go smooth.
good luck for endeavors.
Thanks,
John.
It will drop publications and subscriptions.
If I were you, I would script out the publications and subscriptions, (right
click on your publication and select generate sql script to do this).
upgrade your database, and then reapply the scripts.
There is something bothering me about your post though - it sounds like you
are about to do this in a production environment. I would advise you to do
this in a test environment first to see what will happen.
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
"John" <John@.discussions.microsoft.com> wrote in message
news:29AC881F-3837-4BE8-BB9F-AFA8DF6CAB13@.microsoft.com...
> Hi,
> we are adding new verisons of databases to out SQL Instance. we want to
> disable existing databases replication, with out effecting production db
> replication process.
> i think if u use GUI, SQL Server will disable all the prublications? i am
> not sure this is correct or wrong.
> please advise me, the scripts which should execute, perform and go smooth.
> good luck for endeavors.
> Thanks,
> John.

没有评论:

发表评论