Post reply

Mirroring & Partitioning

  • September 17, 2014 at 5:47 am

    #293323

    Hi,

    When the database is configured for mirroring and you want to do partitioning on that database, How can we do?

    Is this similar process or any variation there while adding file groups and files? The partition will reflect in the mirroring database also?

  • September 17, 2014 at 6:54 am

    #1746034

    You can add partitioning to a mirrored database as normal, all DDL changes will be pushed across.

    This is also true for adding files & filegroups. Just make sure that the filepaths for the new files exist on the mirrored server otherwise the mirroring session will become paused.

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

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