Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Transaction log of xcAdmin database consumes disk space
설명
The transaction log of the xcAdmin database is consuming too much disk space. Is there a way to trim it?
원인
The transaction log of the xcAdmin database can increase in size because it is recording every action that is done in ControlPoint, including the nightly discovery.
해결 방안
Open SQL Management Studio on the server that has the xcAdmin database.
Right-click on the xcAdmin database and select Properties.
In the Select a page pane, click Options.
Change the Recovery Model to Simple, and then click OK.
Run the SQL query below to shrink the log file.
Use xcAdmin
DBCC SHRINKFILE(xcAdmin_log, 10)
BACKUP LOG xcAdmin WITH TRUNCATE ONLY
DBCC SHRINKFILE(xcAdmin_log, 10)
