Home
Mail to developer
FAQ

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
Your opinion on this matter is taken into account. Thank you!
© "Double B" JSC, 2023