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
    fudiu, Apr 26, 2005
    #2

  2. satya Moderator

    On the secondary server:

    RESTORE LOG [dbname] WITH RECOVERY

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Apr 26, 2005
    #2

  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
    fudiu, Apr 26, 2005
    #2

  4. derrickleggett New Member

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

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
    derrickleggett, Apr 26, 2005
    #2

Share This Page