Replication and Adding files/Filegroups

• SuperDBA-207096

  SSCrazy Eights

  Points: 8176

  More actions

  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

• Chuck Hottle

  SSCarpal Tunnel

  Points: 4777

  More actions

  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.