Post reply

Replication and Adding files/Filegroups

  • September 14, 2011 at 9:10 am

    #247644

    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

  • September 14, 2011 at 10:23 am

    #1381458

    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