Post reply

SQL Server 2000 Log Shipping Secondary Server Failed

  • November 30, 2008 at 9:43 pm

    #383485

    Hi,

    I have a set-up of LogShipping onto 3 servers, Primary, Secondary (Stand-By DB) and Monitoring servers.

    If for no apparent reason, the Secondary Server failed or machine where the stand-by DB sits broke down. What steps do I have to do to be able to rebuild the secondary server (stand-by DB). Can anyone please enlighten me.

    Thanks in advance.

    Tolitz

  • November 30, 2008 at 10:09 pm

    #905365

    Hi Tolitz

    in the scenario where your secondary db gets corrupted, the only way out is to take the backup of database from primary server and restore it on secondary server and finally start log shipping again.

    Anam

  • November 30, 2008 at 10:11 pm

    #905367

    I could think of the following steps:

    1.Remove logshipping on the primary.

    2.Restore/Reinstall the secondary.

    4.Restore the latest Fullbackups of the logshipped DBs.

    3.Reconfigure logshipping.

    Regards,

    -Hope is a heuristic search :smooooth: ~Hemanth

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

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