Post reply

how to stop log shipping

  • August 11, 2003 at 9:56 am

    #59088

    I have defined log-shipping between my test servers. Now I need to stop. Is there a way to stop it, without deleting the databases?

    Thanks much.

  • August 12, 2003 at 4:09 am

    #469525

    hi,

    try :-

    restore {db_name} with recovery

    on the secondary database to bring it on-line and no further transaction logs will be able to be loaded. And just disable the transaction log dump on the primary side.

    Paul

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

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