replicating databases in two remote offices

Posted on 2005-04-30
Last Modified: 2010-03-19
how can i a keep 2 databases a sychronized as possible in two different offices? both databases run off websites with a different extentension. (.cc and .net). i need both updated as much as possible incase one of the sited goes down. im a new network administrator and really do not know much about databases so please explain as simply as possible. i have vpn setup on both sites if that helps. thanks
Question by:andreb2005
    LVL 34

    Expert Comment

    How "up to date" do you want to keep the sites?

    There are several forms of replication you could use--depends on your requirements.  Personally, I would direct both of your websites to the same database, and , on the backup, setup logshipping to another server.

    Author Comment

    well i would like to keep it as p to dat as possible but at the very minimum once a day. the boss does not want to use the same database, that is the point of having it in 2 different location incase one fails.
    LVL 34

    Expert Comment

    "the boss does not want to use the same database, that is the point of having it in 2 different location incase one fails."

    Did you read my post?  The websites hit one central location.  However, you have another SQL hosted on the backend that you logship or replicate to.  In the event of a failover, you bring the other server online--no code changes.  The way you have it setup now, you either change code to point to another database server when the site fails, or you change DNS (which could actually take a couple of days to populate everywhere).

    Author Comment

    what is logshipping
    LVL 34

    Accepted Solution

    It's when you perform a log backup of your database and copy (ship) it to another server and restore it.

    It's built in to SQL Enterprise edition via a maintenance plan.  However, you can manually set it up on any version (it works really slick--we use it on several of our disaster recovery plans for clients).  Here is a brief overview and how you can config it:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    SQL Server Fine Tuning 7 38
    report c# 9 56
    Order by but want it in specific order 2 14
    Which one to download? 8 28
    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now