Changing the size of the SQL Server Express transaction log

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. 

                  New to ADSelfService Plus?

                    • Related Articles

                    • MSSQL Transaction Logs Full

                      Steps to clear the Transaction logs. 1. Shutdown opmanager service. 2. Change the Recovery Model to Simple by following the steps below: Go to SQL server-->OpManagerDB properties-->Options-->Recovery Model-->Simple. (You can replace it with full mode ...
                    • Log Analysis

                      Every action in OpManager leaves a trace(s) in the log files. There are two logs folder in OpManager. One under the OpManager directory and the other under OpManager tomcat folder.   The logs folder under the OpManager directory contains various logs ...
                    • Changing Web Server port in OpManager

                      You will be prompted to change Web Server port during installation. You can also change it after installation. Note: It is mandatory to change the OpManager port only from the UI, if any agent-monitored devices are present. Steps to change the port ...
                    • Moving OpManager from one server to another server without reinstalling OpManager

                      Question : How do I move OpManager from one server to another without reinstalling OpManager. Solution:  It is easy to move OpManager from one Server to another just by copying  the complete OpManager folder and installing  the service. Steps: 1)Stop ...
                    • Log monitoring agent not communicating with server after enabling SSL

                      Error trace in agent logs: 2016/09/20  00:22:49:235 InternetGetRequestEx :  The request is updated with the internet option security flags. 2016/09/20  00:22:49:251 InternetGetRequestEx :  Error in WinHttpSendRequest -> -2146892963 2016/09/20  ...