SQL Server Performance Forum – Threads Archive
Log Shipping & Backup LogHello 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.
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
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.