Changing the size of the SQL Server Express transaction log
Question: How do I increase my SQL Server Express transaction log size?
This article provides steps to change the size of the SQL Server Express transaction log. You may want to change the log size to, for example, restrict its growth.
Solution:
To change the size SQL Server Express transaction log, connect to the server database using Microsoft SQL Server Management Studio:
1)Right-click on the required Database and click Properties.
2)Click Files.
3)Click the icon in the Autogrowth column.
4)From this screen, select your preferred options to modify the size and click OK.
This article provides steps to change the size of the SQL Server Express transaction log. You may want to change the log size to, for example, restrict its growth.
Solution:
To change the size SQL Server Express transaction log, connect to the server database using Microsoft SQL Server Management Studio:
1)Right-click on the required Database and click Properties.
2)Click Files.
3)Click the icon in the Autogrowth column.
4)From this screen, select your preferred options to modify the size and click OK.