SQL Server Performance

Log shipping setup - copy transaction log

Discussion in 'SQL Server Log Shipping' started by feann, Apr 11, 2005.

  1. feann New Member

    the system will perform full backup at 1 am
    there will be some transactions started from 9 am
    log shipping will be configured at 11:45am and the backup from 1am will be used
    after the log shipping is configured, how the copy task run to make sure the transaction b/w 9am and 11:45am will be synchronized to stand by server ?

    the task of copying log will copy the lastest transaction log to standby server
    or .. it will extract the transactions b/w the internal (9:00 - 9:15, 9:15 - 9:30 ) and copy the files to standby
  2. satya Moderator

    If the full backup is performed and applied to secondary server, and then the log shipping will take care of schedule of log restore on secondary server.

    According to the log shipping schedule the log backups will be performed and restored.

    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.
  3. feann New Member

    how about if the full backup is not the latest snapshot of the primary server?
  4. satya Moderator

    The log restore will fail due to mismatch of LSN on full backup and log backup.

    I think you must need a refresh on log architecture of SQL SErver to know more about it.
    Books online is your best pal.

    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