Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I just have a few questions regarding the setup of Always On HA, and Clusters. When you setup an AG, and it gets to setting up your IP address for the cluster how can i switch from using DHCP to a static IP address? I have it working with DHCP right now but in the future I would like to change that for my existing AG and also for future groups I setup. It does not seem like I'm being given the option in my setup though.

The second question is when setting up the group to use full sync it works just fine. However What I am trying to figure out is where that sync data is stored. I am using Synchronous-commit mode. From what it looks like the initial sync, and the data that is mirrored is stored and applied in a basic log I just cannot seem to find where that log is stored.

Any information or links would be greatly appreciated.

share|improve this question
    
check this link (brentozar.com/archive/2012/07/…) on www.brentozar.com/ –  user10198 Jul 17 '12 at 17:05
add comment

migrated from stackoverflow.com Jul 16 '12 at 16:28

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 2 down vote accepted

If you right click on the availability group listener and click properties you can change the IP address from dhcp to a static ip.

As for where the data is stored prior to transfer, it is stored in the transaction log.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.