Mirroring & Partitioning

  • 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?

  • 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