Best Approach to move the databases in Always On

  • Hi,

    We have Always on Server with one primary & 1 secondary ( Not readable). The current drive is almost full. We have about 10 databases in the Always on Availability group. How can we the databases (At least few DBs) to another drive with out downtime?

  • I Googled the title of your post... you should try it. 😉

    We don't use AG at work and so I've not actually used it.  If I were put on the spot to do something like you ask, I'd Google for the info and read the documentation.  In my Google search, I found the following article.  I've not studied it nor even completely read it but, from the little I did read, the author seems pretty savvy.

    https://datamasterminds.io/moving-database-files-with-minimal-downtime/

    I'll also suggest that "NO DOWNTIME" is wishful thinking but you can help minimize it.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • This was removed by the editor as SPAM

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

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