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 ...
                    • 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  ...
                    • SQL Injection Vulnerability FIx

                      Vulnerability: Blind SQL injection (unauthenticated) Fix: Upgrade to Social IT vXXXX; OpManager vXXXX; IT360 vXXXX Constraints: no authentication needed for OpManager and Social IT; authenticated in IT360 a) POST ...