SQL Server Performance

Log Shipping & Backup Log

Discussion in 'SQL Server Log Shipping' started by mramsey22, Mar 14, 2007.

  1. mramsey22 New Member

    Hello all,

    How does one CLEAR the log (backup log) if log shipping is enabled? Does the log shipping process perform a backup log after it has applied that log to the secondary db?

    What operations are NOT allowed if log shipping is ENABLED? Lets say, will doing a bcp in out BREAK log shipping?

    Thanks.
  2. satya Moderator

    No need to perform any manual or intermittent truncation of log, once the log is written to disk and transfered to secondary server the log is truncated on the primary server by the process itself.

    Bulk load operations must be taken care, you have to stop log shipping during this process adn once finished ensure to backup and restore database on secondary server.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page