Using DNS, Fail over sql server databases, Web sites etc.

Discussion in 'DNS Server' started by Kishor Yadav, Dec 16, 2005.

  1. Kishor Yadav

    Kishor Yadav Guest


    I am working on DNS. I want to know whether fail over databases from one sql
    server to another and fail over web sites can be done through DNS?.

    How can I implement this, any procedure, ideas?,

    I would be grateful if somebody can help me on this,

    Thank You,
    K L Yadav
    Kishor Yadav, Dec 16, 2005
    1. Advertisements

  2. As I understood you want add multipe A records to enable fault tolerance, to
    do so simply add multipe A records with the same fqdn of your server. You
    also can enable Round Robin feature in DNS server (advanced tab) to enable
    load balancing.
    Simas Kvilius, Dec 16, 2005
    1. Advertisements

  3. DNS can only publish IP address for a particular name, if DNS publishes two
    or more IP addresses for the same name, it is up to the application making
    the query to failover to a second IP address.

    I know of no web browsers that will do this, they just connect to the first
    IP address returned to them. If the site is down, you'll just get an error.
    There are web server applications with the ability to do this. such as what
    you find in web server "farms" but this is out of my field of expertise.

    Best regards,
    Kevin D. Goodknecht Sr. [MVP]
    Hope This Helps
    When responding to posts, please "Reply to Group"
    via your newsreader so that others may learn and
    benefit from your issue, to respond directly to
    me remove the nospam. from my email address.
    Use Outlook Express?... Get OE_Quotefix:
    It will strip signature out and more
    Keep a back up of your OE settings and folders
    with OEBackup:
    Kevin D. Goodknecht Sr. [MVP], Dec 16, 2005
  4. I never tried to test behaviour of web browser in such situation, but appeal
    to 70-291 self-paced training kit (page 5-46) dns client should always use
    second A record if first fails.
    Simas Kvilius, Dec 16, 2005
  5. You are right I tried to simulate similar situation and my request failed.
    Simas Kvilius, Dec 16, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.