SQL Server Performance

restore log

Discussion in 'SQL Server Log Shipping' started by fudiu, Apr 26, 2005.

  1. fudiu New Member

    If the primary server is out of service suddenly, the secondary server will act as primary server. if the last transaction log had been restored, how to make the loading database to operational mode on secondary server
  2. satya Moderator

    On the secondary server:


    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. fudiu New Member

    is it ok to restore the db with recovery by GUI without specify the last transaction log providing that the last transaction log had been restored
  4. derrickleggett New Member

    ? Just do it in QA using the script Satya gave you.

    [email protected]

    When life gives you a lemon, fire the DBA.

Share This Page