controlling size of log file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

controlling size of log file

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
Try to eliminate long running transactions and schedule more frequent trans log backups.
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.
]]>