Post reply

Table migration to FileGroup in AlwaysOn

  • April 14, 2016 at 9:42 am

    #315523

    Hi Everyone

    I have a 2 TB Production db in AlwaysOn synchronous auto failover mode.

    I have a 600GB(230 million rows) table which I would like to move to it's own file group in a different drive.

    I only have a 36 hour maintenance window to do this and wasn't sure if I should keep the DB in AlwaysOn or remove it.

    Has anyone done table to filegroup migration in AlwaysOn?

    Should I remove the DB from AlwaysOn and set it simple recovery model?

    Thank you

    Alex S

  • April 14, 2016 at 10:58 am

    #1872090

    AlexSQLForums (4/14/2016)

    Hi Everyone

    I have a 2 TB Production db in AlwaysOn synchronous auto failover mode.

    I have a 600GB(230 million rows) table which I would like to move to it's own file group in a different drive.

    I only have a 36 hour maintenance window to do this and wasn't sure if I should keep the DB in AlwaysOn or remove it.

    Has anyone done table to filegroup migration in AlwaysOn?

    Should I remove the DB from AlwaysOn and set it simple recovery model?

    Thank you

    Do the file paths match between the replicas?

    i.e. if you want to create new filegroup and file on 'G:\data\mydbewfile.ndf', does this path exist on the replicas

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 14, 2016 at 12:25 pm

    #1872134

    Perry Whittle (4/14/2016)

    AlexSQLForums (4/14/2016)

    Hi Everyone

    I have a 2 TB Production db in AlwaysOn synchronous auto failover mode.

    I have a 600GB(230 million rows) table which I would like to move to it's own file group in a different drive.

    I only have a 36 hour maintenance window to do this and wasn't sure if I should keep the DB in AlwaysOn or remove it.

    Has anyone done table to filegroup migration in AlwaysOn?

    Should I remove the DB from AlwaysOn and set it simple recovery model?

    Thank you

    Do the file paths match between the replicas?

    i.e. if you want to create new filegroup and file on 'G:\data\mydbewfile.ndf', does this path exist on the replicas

    Hi Perry

    Yes both VM's have exact same cpu, ram, disk drives, letters and space.

    I have already created the new filegroup and ndf.

    Alex S

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

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