Friday, March 9, 2012

Detach db file with replication on

I cannot detach a db because replication is enabled . I wanted to detach
this published db so that I can move the files to another drive .
But at the same time, dont want to drop replication to do this. Is there a
way to be able to detach the db without dropping replication . ?
Hassan,
you could use backup and restore, however if the new server name is
different to the original, practically speaking, you'll end up having to
recreate the publications.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Backup and restore may be a good option.. I can use the with move option and
do it.. Thanks..
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ep2Ot2MLFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Hassan,
> you could use backup and restore, however if the new server name is
> different to the original, practically speaking, you'll end up having to
> recreate the publications.
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

No comments:

Post a Comment