![]() ![]() You can see that Endpoint Central log size will now be reduced in the MSSQL database. Restart UEMS Server from the machine, where it is installed.Refer to the steps recommended in the Microsoft article for more details: Steps to Alter Database File and Filegroup Options Alter database MODIFY FILE (Name = "_log",MAXSIZE=5 GB)Įxample: Alter database desktopcentral MODIFY FILE (Name = "desktopcentral_log",MAXSIZE=5 GB), which means Endpoint Central log size will not exceed 5 GB You can use this to increase or decrease the memory used for storing the transaction logs. Alter Database Modify File, can be used to alter the size of the transaction logs.It is recommended only for large database.ĭBCC SHRINKDATABASE (database name, target percent)Įxample: DBCC SHRINKDATABASE (desktopcentral,20) ![]() If you specify the value as "20%" then the size of the database will be shrunk by 20%, if there is available free space. In other words, CCPs act as risk managers, transparently keeping collateral of financial transactions from the original trading counterparties to secure the trades, and reduce risk exposure. Using this query, you can determine the size of the database and shrink the available free space in terms of percentage. Central clearing directly reduces counterparty risk, thus protecting market participants in the event of default. The following query is recommended by Microsoft, to shrink the size of the Endpoint Central database. Shrink the size of the Endpoint Central database.You can choose to either shrink the size of the log or alter the size of the log as mentioned below: Under New Query, connect to Endpoint Central database to execute the one of the following queries.Navigate to " desktopcentral" database and right click it. ![]() Steps to change recovery model to "Simple" The following steps needs to be performed on the computer, where MS SQL database is configured:
0 Comments
Leave a Reply. |