Thursday, February 9, 2012

Attach Question

Hello,
I'm having problems removing replication components from a db I need to
detach and move to a different server. The db won't be using replication on
the new server. Since all replication components aren't removed Ent Mgr
won't let me detach. Can I just stop the SQL services, copy the .mdf to the
new server, attach and cleanup replication there?
Any help appreciated!
Thanks in advance.Hi Mark
Taking a backup will be better than stopping the server.
You can remove replication using sp_removedbreplication and possibly
sp_dropdistributor see the topic "How to: Disable Publishing and
Distribution" in Books Online
John
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:0EA3E109-446C-4337-963C-1B7C120F3F52@.microsoft.com...
> Hello,
> I'm having problems removing replication components from a db I need to
> detach and move to a different server. The db won't be using replication
> on
> the new server. Since all replication components aren't removed Ent Mgr
> won't let me detach. Can I just stop the SQL services, copy the .mdf to
> the
> new server, attach and cleanup replication there?
> Any help appreciated!
> Thanks in advance.

No comments:

Post a Comment