SQL Fail Over

Posted on 2006-05-18
Last Modified: 2012-05-05
My SQL skills are not the best but i now need to set up replication for failover purposes.  

I have a core server with a business critical database which needs to replicate in realtime to a second server.  Not bothered about failover just need it to work like disk mirroring so that if i loose a server i instantly have access to that database.

Can anyone talk me through the process in simple terms
Question by:higgsy
    LVL 50

    Expert Comment

    replication won't guarantee that you don't lose data...
    just that the minimum amount will be lost...

    any failover is up to you to control...

    you probably also want to read up on Clustering / cluster server(ices)


    sorry haven't time for anything fuller.
    LVL 10

    Expert Comment

    I disagree ... Clustering will require a SAN, I would use Log shipping , this allows you to easily setup a stanby database 'with no auto failover .. same a replication' without the overhead of replication .... you can set up log shipping to run every 5 minutes ....  

    or if you goto sql2005 you could look at DB mirroring even better

    Author Comment

    Cool how would this be done??? log shipping?? is the the easiest way to failover a database.

    A 5 minute delay is not a problem
    LVL 10

    Expert Comment

    are you using sql 2000 or 2005 .. and what version of sql are you running ? standard or enterprise

    Author Comment

    SQL 2000 standard
    LVL 10

    Accepted Solution

    The log shipping feature is only available in the Enterprise Edition of SQL Server 2000.
    You can build your own homegrown solution by taking a backup of the db's
    in question and copying it to another server, then having the logs cut and
    copied to the other server and applying the backup and the logs
    sequentially. There are some scripts online if you look for "custom
    logshipping ". or check out


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    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, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    745 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

    15 Experts available now in Live!

    Get 1:1 Help Now