I've got a couple of replicated databases and I've found myself in the
position of wanting to move my distribution database to a different storage
volume. Enterprise manager considers it replicated, so I can't just detach
it, copy and reattach. Anyone know of a good way to do this?
Thanks!
Patrick Peters
patrick.peters at orametrix dot com (fix the reply address for this message
if you're sending email to me)
Hi,
I think you need to completely remove replication and then start over from
start.
Thanks
Hari
SQL Server MVP
"Patrick Peters" <patrick.peters at orametrix dot com> wrote in message
news:uLz0vzFnFHA.1968@.TK2MSFTNGP14.phx.gbl...
> I've got a couple of replicated databases and I've found myself in the
> position of wanting to move my distribution database to a different
> storage volume. Enterprise manager considers it replicated, so I can't
> just detach it, copy and reattach. Anyone know of a good way to do this?
> Thanks!
> Patrick Peters
> patrick.peters at orametrix dot com (fix the reply address for this
> message if you're sending email to me)
>
|||I was hoping for something less painfull than that. This is, however, what
we ended up doing. Luckily the amount of data involved is small right now.
In a couple of months, this solution would have been unacceptable.
Pat
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OQ4ehNGnFHA.3448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I think you need to completely remove replication and then start over from
> start.
> Thanks
> Hari
> SQL Server MVP
> "Patrick Peters" <patrick.peters at orametrix dot com> wrote in message
> news:uLz0vzFnFHA.1968@.TK2MSFTNGP14.phx.gbl...
>
Wednesday, March 7, 2012
move distribution database to other storage
Labels:
couple,
database,
databases,
distribution,
ive,
microsoft,
mysql,
oracle,
replicated,
server,
sql,
storage,
theposition
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment