Post reply

Moving AlwaysOn database tlogs to another drive.

  • September 6, 2017 at 9:24 am

    #348895

    Hi Everyone
    We have a 6 node cluster which contains 1 primary, 1 secondary and 1 tertiary AOAG.
    The tlogs on primary are on the right drive but in 2nd and 3rd they are in the wrong drives.
    Is there a way to move tlogs to another drive without taking out the db's from AOAG?
    Can I remove the db from 2nd and 3rd and then offline them move the tlogs and online and then add it back to AOAG?

    Alex S

  • September 6, 2017 at 11:30 am

    #1958412

    Pretty sure you will need to remove the databases from the AG, and then re-add them back which will require database restores with no recovery as you know which is where the new transaction log locations for the non-primaries would be defined.

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

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