Post reply

how to create stand by server?

  • August 2, 2007 at 6:44 am

    #69664

    Hi friends.

    please tell me the concept of stand by server and how it is used?

    in my case data importance is very high. so i want to make stand by server that continuesly take data from main server, in any case of failure of main server we are able to start stand by server.

    so please tell me wht are the procedure to create stand by server and wht task sheduled for main server to generate data...the transferred to stand by server

    thanks

  • August 2, 2007 at 7:27 am

    #724157

    this might help !

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

  • August 2, 2007 at 10:08 am

    #724252

    I believe the poster would like to have a standby server not a cluster server. I believe that we can use log shipping. Enterprise edition has this function built-in. If we use other SQL Server edition, we have to write scripts by ourselves. Its concept is not hard.

    Copy transaction logs periodically;

    Ship the log backup to your standby server;

    Restore the log backups;

     

  • August 2, 2007 at 7:34 pm

    #724368

    The standby servers act as a backup server.....if your production server is highly critical and you cant tolerate any downtime you can make use of the standby server.Unfortunately if the production server is down you can immediately make use of the standby server and repoint all the users and applications to this standby server immediately......you can make use of the following techniques for providing high availability solutions namely,

    Log shipping in sql 2005

    Database mirroring in sql 2005

    if you have sql 2000 you can use only log shipping with Enterprise edition....so better go for sql 2005.......refer this site,

    http://sql-articles.com/

    http://sql-articles.com/articles/dbmrr.htm ---> database mirroring

    http://sql-articles.com/articles/lship/lship.htm---> log shipping

    prerequisites are also available pls check and revert if you have any concerns

    [font="Verdana"]- Deepak[/font]

  • August 2, 2007 at 10:19 pm

    #724378

    You can have log shipping in any edition of SQL Server 2000 and 2005.

    For the editions that don't come with it builtin ( which is sometimes more trouble than its worth ) you can use a set of custom T-SQL scripts of which there are dozens available on the internet.

    Deepak, your articles are pretty good, but you should make it clear that you're only dealing with the builtin log shipping and there are other options.

    --------------------
    Colt 45 - the original point and click interface

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply