Replication and Adding files/Filegroups

  • In SQL Server 2005, I am using replication - both transactional and peer to peer. I need to do some partioning on my main DB. Is there a way to do this without affecting replication?

    The last time I tried it - it broke replication. it takes a long time to re-create my subscription DB's, and I would like to avoid having to do so if possible.

    Thanks!!!!

    Mark

  • I don't think if you're moving primary key indexes to a new file group for replicated tables that you can avoid having to redo replicaton. We regularly move indexes to new file groups and we avoid moving the ones that fit that criteria because we also have some very large articles and many subscribers.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply