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
Was this answer helpful for You?
Please tell us how we can make this answer more helpful.

Your comment:


Your e-mail:

Enter the text from the image:         

 
 
© "Double B" JSC, 2023