Post reply

Log Shipping or Replication

  • August 15, 2005 at 6:05 pm

    #114841

    I am planning a warm standby system. It seems that SQL Server 2000 provides at least two ways to get make the primary and the standby database in sync, log shipping and replication.

    I hope you SQL Server experts can tell me what are the pros and cons of these two. In particular in terms of impact on the production (source or publicher), network traffic, availability of the standby (destination or subscriber) and degree of difficulty in configureation.

    Thanks

  • August 15, 2005 at 6:39 pm

    #582319

    Depends on what you are wanting to do. If this is for a drp solution I suggest you look at using log shipping. If it for reporting  then perhaps you look at replication. But either will do for reporting purposes. However in the log shipping situation there will be "blackout" periods when logs are applied.ie Database will be unavailable.

    Check out these links

    http://vyaskn.tripod.com/maintaining_standby_sql_server.htm

    http://www.sql-server-performance.com/sql_server_log_shipping.asp

  • August 16, 2005 at 10:46 am

    #582559

    Thank.

    The articles are very good.

Viewing 3 posts - 1 through 2 (of 2 total)

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