Post reply

Partition on Log Shipping database(primary database)

  • June 11, 2014 at 7:04 am

    #287431

    Hi all

    I would like to do partitioning one of my client, but that primary database is participating in log shipping, can you suggest best method,

    If I do partitioning on primary, automatically apply those changes on secondary db? if not, what is the way?

    Note: I am adding new filegroups and ndf file in different drives on primary database.

  • June 11, 2014 at 1:00 pm

    #1720880

    Yes, Partititioning on primary gets replicated to Secondary. remember, Adding file, modifying file are part of ALTER Database command so should be logshipped to secondary and there will not be any issues.

  • June 12, 2014 at 12:17 am

    #1720932

    Nalini D (6/11/2014)

    Yes, Partititioning on primary gets replicated to Secondary. remember, Adding file, modifying file are part of ALTER Database command so should be logshipped to secondary and there will not be any issues.

    I have added new filegroup and new ndf file in primary database. But restore job got failed due to new filegruop&ndf file creation.

    so your method not working , any idea?

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

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