SQL Server Performance

Log shiiping process

Discussion in 'SQL Server Log Shipping' started by mahesh, Jun 12, 2004.

  1. mahesh New Member

    Hi,

    If my production server is up then can i able to remove read only tag of database which resides on stand by server.
  2. derrickleggett New Member

    RESTORE database WITH RECOVERY

    After you do this, you can't restore any more transaction log backups though.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. satya Moderator

    Log shipping is a very useful method of creating warm standby failover server as well as providing separate reporting server. Using this feature can provide significant benefits in relevant business scenarios.

    But ensure users are disconnected from standby database, when the next schedule of Log shipping is trying to restore the transaction log. Otherwise the jobs will fail.

    If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from differential) are planned, NORECOVERY or STANDBY should be specified instead.

    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.

Share This Page