Post reply

Log shipping Tran log path

  • October 23, 2011 at 10:51 am

    #261863

    Hi Friends,

    I have configured the Logshipping -Copy Job (Which copies tran logs from Primary Server) to copy all the tran logs to E:\ Drive on Secondary Server, i need to change it to G:\ Drive instead.

    Is there any other way around to do this without re-configuring the log shipping from the scrap?

    Kindly advice me.

    Thanks,

    Vinoth

  • October 23, 2011 at 1:28 pm

    #1398475

    vino5786 (10/23/2011)

    Hi Friends,

    I have configured the Logshipping -Copy Job (Which copies tran logs from Primary Server) to copy all the tran logs to E:\ Drive on Secondary Server, i need to change it to G:\ Drive instead.

    Is there any other way around to do this without re-configuring the log shipping from the scrap?

    Kindly advice me.

    Thanks,

    Vinoth

    use the following stored procedure to change this

    sp_change_log_shipping_secondary_primary

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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