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 later)
3. Connect to MSSQL Server-->OpManagerDB. Execute the following query
1) DBCC SHRINKDATABASE (database name , target percent)
for eg
DBCC SHRINKDATABASE (opmanagerdb,20)
2) alter database <DATABASENAME > MODIFY FILE (Name = "<DATABASENAME>_log",MAXSIZE=1 GB)
- for eg
alter database OpManagerDB MODIFY FILE (Name = "OpManagerDB_log",MAXSIZE=1 GB)
(If the transaction log is too huge without any backup, it can not shrink. So run this query and then follow the above steps
BACKUP LOG OpManagerDB WITH TRUNCATE_ONLY
4. Restart OpManager Service.
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 later)
3. Connect to MSSQL Server-->OpManagerDB. Execute the following query
1) DBCC SHRINKDATABASE (database name , target percent)
for eg
DBCC SHRINKDATABASE (opmanagerdb,20)
2) alter database <DATABASENAME > MODIFY FILE (Name = "<DATABASENAME>_log",MAXSIZE=1 GB)
- for eg
alter database OpManagerDB MODIFY FILE (Name = "OpManagerDB_log",MAXSIZE=1 GB)
(If the transaction log is too huge without any backup, it can not shrink. So run this query and then follow the above steps
BACKUP LOG OpManagerDB WITH TRUNCATE_ONLY
4. Restart OpManager Service.
New to ADSelfService Plus?
Related Articles
OpManager Enterprise installation procedure for central and probe on a Windows server (MSSQL)
OpManager DB migration from PGSQL to MSSQL on the same server in Version 12.3
Please follow the below mentioned steps to migrate DB from PGSQL to MSSQL on the same server. These steps are applicable only on builds 12.3.045 and above. If you are in older versions below 12.3.045, please upgrade to 12.3.045 and follow these ...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: ...OpManager stops after the user logs off
Issue : If the OpManager Service runs on a service account (This Account). It will NOT allow you to keep the Wrapper running after the user mentioned (This Account) logs off. It happens only in Windows 2003 R2. Solution : Change the Service ...No Database listed while adding MSSQL Monitors
Issue/Scenario: When I try to add MSSQL performance Monitors, I get to the stage to add databases but there were no databases listed . This issue could occur if 32bit MSSQL is installed on a 64bit Widows2008 R2. Solution/Workaround: Apparently ...