ManageEngine Forums

Purge database (MSSQL)

in AppManager  •  General  •  26 May 2011
Is there a way to delete old data from the database if it's using MS SQL Server?
 
I tried using the reinitialize.bat script, however this seems to be looking for a MySQL database.
 
I'm using SQL 2008 Express Edition, and my Applications Manager database has reached 4 GB which is the limit on this version of SQL - hence I need to purge the old data. I'm not bothered about keeping any of the existing data, I'd really like to start from scratch if possible?

Replies (3)

Paul Jacob Employee

Hi,

If the Transaction Logs settings of your MS SQL DB is not managed correctly check the following troubleshooting steps as recomended by microsoft:

http://support.microsoft.com/kb/873235

http://technet.microsoft.com/en-us/library/ms175495.aspx

http://support.microsoft.com/kb/317375

If you are trying to start from scratch then you may stop Applications Manager and drop the AMDB database for Applications Manager by connecting to the SQL Server from SQL Administrator tool. Now when you restart Applications Manager the database will be re-created as new.
 
Thanks & Regards,
Paul Jacob
Thanks - stopping Applications Manager and dropping the database did exactly what I needed.
 
For future reference, is there any way of setting how long the collected data (history) should be kept for? By default, how long is the data kept?
 
Cheers, Cath
Paul Jacob Employee
Hi,
 
Database retention settings can be set from Admin Tab-->Report Settings-->Data Retention (As per 9500 build).
 
The recomended build for Applications Manager is 9500. If you are on an older build version you can upgrade to 9500:
 
Please download service pack (Build No. 9500) from the following link and follow steps in the web page to apply service pack:
 
 
Thanks & Regards,
Paul Jacob