SQL Server Performance Forum – Threads Archive
Sql 2005 transaction log too big
HiWe just upgrade to Sql 2005, how do I setup so that the transaction log should be committed at day end and clear up ? thanks May the best cheaters win
by the way I know how to detached and shrink manually but not auto setup May the best cheaters win
Make it use of SIMPLE recovery model and set a size to the database whereby schedule a job to truncate log at every 4 hours. 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.
this is a FAQ http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18299
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18987
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18558
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19049 Madhu
thank you <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />May the best cheaters win
]]>