magarity (11/7/2009)
Since all I have is a dev server I wish the logs would go away automatically. I understand the importance of production systems' logs but I have no need for them - if there's a problem of any kind, I just reload my test files in barely a minute. From my POV logs hanging around after commit just clog up space, dang things.
If you use the Simple recovery mode than you do not have to worry about the logs on the development server. The SQL Server will deal with them automatically. Unfortunatelly (or fortunatelly - depending on your point of view) you must have a transaction log for each database on SQL Server. You may not have a need for them but they are critical to the SQL Server's reliability.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]