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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I 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

migrated from Jul 16 '12 at 16:28

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

check this link (…) on – user10198 Jul 17 '12 at 17:05
up vote 3 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

Your Answer


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.