How is it possible to limit the growth of Log-File (Transaction Log) Microsoft SQL Server?

Do the following to change the setting which determines the growth of Log-file Microsoft SQL Server:

1. Start the Enterprize Manager (or Management Studio in SQL Server 2005);
2. Set the focus on the database, right click the form Properties;
3. Click the tab Options and in the Recovery-Model set to "Simple"

Close the form clicking on the "OK" button.
After this set-up installation Log-file will only grow slightly and will be automatically overwritten.
<< back