Always on

  • I have configured always on in one of my server , I need to add a data file to a database which is on AG group how can we add the file

  • Please post in the correct forum for faster results.

    Do the data file locations on the primary and secondary(s) match?

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

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

  • Yes .. the drives are same in both the servers

  • The drives and the folder paths where the database files reside?

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

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

  • The drives and the folder paths where the database files reside?

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

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

  • We configured mdf's in K drive and .ldf's in L drive existing in both the nodes ..

  • Yea but do the folder paths also match?

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

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

  • The paths are also same

    k:\data

    l:\data

  • Then there should be no failed create file operations

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

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

Viewing 9 posts - 1 through 8 (of 8 total)

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