May 15, 2015 at 8:14 am
one of my database is configured in availability group , I need to add another datafile to that database , how can I do this?
May 15, 2015 at 8:17 am
and also how to increase the size of the primary file on the database configured in AG ?
May 15, 2015 at 9:08 am
ramyours2003 (5/15/2015)
one of my database is configured in availability group , I need to add another datafile to that database , how can I do this?
Do all the replicas have the same disk paths and drive letters?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2015 at 9:10 am
yes ..
May 18, 2015 at 3:36 am
then an add file operation should not cause any issues
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2015 at 8:48 am
Mean adding a file same as in mirroring , if the fiels are not in same drives use with move .. Is is right ?
or do we need to follow the procedure same as in mirroring like drop mirroring and add fiel etc...
May 18, 2015 at 9:57 am
ramyours2003 (5/18/2015)
Mean adding a file same as in mirroring ,
yes exactly, adding a file in an AlwaysOn group is the same as adding a file in a database mirroring session, AlwaysOn groups after all are essentially just mirror sessions to multiple secondary's. The paths must match for seamless file creation
ramyours2003 (5/18/2015)
if the fiels are not in same drives use with move .. Is is right ?or do we need to follow the procedure same as in mirroring like drop mirroring and add fiel etc...
Detailed here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply