Friday, March 9, 2012

detach/attach a replicated database

Is there some easy way to detach a replicated database without dropping the
replication around it ?
I guess while i was waiting for an answer, i tried to update the category
column in sysdatabases to 0 , detached the db, attached it again and updated
the column back to 1 and looked like everything worked fine.. I inserted a
record and it propogated through
Let me know if this is fine to do..
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e%23kJuvaYFHA.3836@.TK2MSFTNGP10.phx.gbl...
> Is there some easy way to detach a replicated database without dropping
the
> replication around it ?
>
|||that trick is very helpful. It helped me unpublish the replicated database and then re-publish it quickly without going through the painful process again and again.
From http://www.developmentnow.com/g/114_2005_5_0_0_527842/detachattach-a-replicated-database.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
|||that trick is very helpful. It helped me unpublish the replicated database and then re-publish it quickly without going through the painful process again and again.
From http://www.developmentnow.com/g/114_2005_5_0_0_527842/detachattach-a-replicated-database.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

No comments:

Post a Comment