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.
New to ADSelfService Plus?
Related Articles
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 ...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 ...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 ...