January 30, 2014 at 2:09 pm
I always used to create and configure the Data Directories as below:
Instance one on Node1:
Instance Name: AlwaysOnAG1\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Instance two on node2:
Instance Name: AlwaysOnAG2\INS2
E:\SQLData\INS2
F:\SQLLogs\INS2
If we wanted to use Always on Availability groups between Ins1 & Ins2, then we should use the same paths across all of the SQL Server instances. So above Data Directories set up will not work right?
So, Should I change them and keep same directory names & with same instance name on both node as below:
Instance Names: AlwaysOnAG1\INS1 & AlwaysOnAG2\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Thanks
January 30, 2014 at 5:37 pm
Mani-584606 (1/30/2014)
I always used to create and configure the Data Directories as below:Instance one on Node1:
Instance Name: AlwaysOnAG1\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Instance two on node2:
Instance Name: AlwaysOnAG2\INS2
E:\SQLData\INS2
F:\SQLLogs\INS2
If we wanted to use Always on Availability groups between Ins1 & Ins2, then we should use the same paths across all of the SQL Server instances. So above Data Directories set up will not work right?
So, Should I change them and keep same directory names & with same instance name on both node as below:
Instance Names: AlwaysOnAG1\INS1 & AlwaysOnAG2\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Thanks
2 instances should not use the same folders - you can get file collisions if you have same-named files across instances. But it seems you are missing the fact that you actually need FOUR installations here to set up AGs on both INS1 and INS2. One install of INS1A on node 1 and one install of INS1B on node 2, and one install of INS2A on node 1 and one install of INS2B on node 2. INS1A/B will be one AG host pair and INS12A/B will be another AG host pair.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 31, 2014 at 4:05 am
Mani-584606 (1/30/2014)
I always used to create and configure the Data Directories as below:Instance one on Node1:
Instance Name: AlwaysOnAG1\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Instance two on node2:
Instance Name: AlwaysOnAG2\INS2
E:\SQLData\INS2
F:\SQLLogs\INS2
If we wanted to use Always on Availability groups between Ins1 & Ins2, then we should use the same paths across all of the SQL Server instances. So above Data Directories set up will not work right?
So, Should I change them and keep same directory names & with same instance name on both node as below:
Instance Names: AlwaysOnAG1\INS1 & AlwaysOnAG2\INS1
E:\SQLData\INS1
F:\SQLLogs\INS1
Thanks
The only time you'll see an issue is during a file creation process. You could use the following data directories across the instances on their respective nodes
F:\AOGRP1Data
G:\AOGRP1Log
If you had a second AO group you could use
F:\AOGRP2Data
G:\AOGRP2Log
Obviously there are no concerns with instances using the same path as all replicas in a given AO group must be homed on separate nodes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply