Post reply

Log Shipping with SQL 2000 Standard

  • April 3, 2007 at 11:56 am

    #175775

    Hi All,

    I am managing a site, which has SQL 2000 standard version.  There is a backup site at another location.  Currently a programmer copies the t-log everyday to the other location.  Takes too much time.  Is there an automated way to transfer transaction logs to other location and restore it to make the other site a hot-site.

    Thanks

    SQL Surma

  • April 3, 2007 at 1:02 pm

    #698385

    Log shipping is a warm standby solution rather than hot standby because there is no automatic failover.  Since log shipping isn't available in SQL 2000 Standard Edition, you'd need to use a custom process.  This article gives a good description of custom log shipping: http://www.sql-server-performance.com/sql_server_log_shipping.asp

    You might also be interested in transactional replication.  See BooksOnLine or search this site for info.

    Greg

    Greg

  • April 3, 2007 at 1:37 pm

    #698389

    Thanks Greg.  This article is helpful.

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

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