SQL Server Performance

controlling size of log file

Discussion in 'SQL Server Log Shipping' started by sunnylicious, Jul 20, 2005.

  1. sunnylicious New Member

    Hello, after setting up log shipping I notice that the size of the logs is huge...and just continues to increase..how do you manage the size of your log files? do you delete them after a certain time period? keep them at a certain size limitation? any tips? Thanks in advance
  2. mmarovic Active Member

    Try to eliminate long running transactions and schedule more frequent trans log backups.
  3. satya Moderator

    While running bulk load operations then may choose BULK_LOGGED recovery model too.

    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