Post reply

Log Shipping - Reverting back to Primay Server

  • December 5, 2008 at 6:37 am

    #198535

    Hi,

    i have implemented log shipping at our workplace and want to do a simulation of disaster wherein secondary server will assume the role of the primary server and will continue to operate for few hours...

    Assuming i had restored the tail log backups to secondary before changing its role, how do i make sure all incremental data (during the period secondary server was swapped its role) goes back to the primary server... (assuming primary server has been recovered).

    Thanks.

    PS


    Pradeep Singh

  • December 5, 2008 at 7:57 am

    #908322

    Good start

    http://sqlserverpedia.com/wiki/Reversing_Log_Shipping_Roles_(SQL_Server_2005)

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • December 5, 2008 at 9:21 am

    #908414

    Thanks Jerry. My question gets answered in that link.


    Pradeep Singh

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

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