RE:Log Shipping

  • hello there am new to sql 2005 and i would like to know if i can do log shipping on one computer with two instances. One instance acts like the primary server while the other is the secondary server. if this is possible, how is it done?

    Tx

    Timothy.

  • tkatende (1/21/2010)


    hello there am new to sql 2005 and i would like to know if i can do log shipping on one computer with two instances. One instance acts like the primary server while the other is the secondary server. if this is possible, how is it done?

    Tx

    Timothy.

    S,possible

    First Why u want do LS with same machine ?

    -- In case your machine down then you will lose both pri & sec...

    I'd suggested first read the MS article and go ahead.

    http://msdn.microsoft.com/en-us/library/ms187103%28SQL.90%29.aspx

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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