https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387494#M36897 Hello,<BR /><BR />the Size of my SIM Database is actual 47GB. Is there a way to clean up the mess? Wed, 25 Mar 2009 09:51:15 GMT at2oo1 2009-03-25T09:51:15Z https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387494#M36897 Hello,<BR /><BR />the Size of my SIM Database is actual 47GB. Is there a way to clean up the mess? Wed, 25 Mar 2009 09:51:15 GMT https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387494#M36897 at2oo1 2009-03-25T09:51:15Z https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387495#M36898 Do you have the automatic event cleanup turned on in SIM? It will clean up the events after 90 days and remove them from the database.<BR /><BR />Our SQL database with approximately 1400 devices (Servers and iLo) is 305MB Fri, 27 Mar 2009 23:22:44 GMT https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387495#M36898 Graeme Bray 2009-03-27T23:22:44Z https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387496#M36899 I have some events that remain pending. They won't delete. How do you clear them out of the DB? Tue, 31 Mar 2009 23:48:53 GMT https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387496#M36899 Robin Fuller 2009-03-31T23:48:53Z https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387497#M36900 <BR />1. Look into database.admin file for your db server<BR /><BR />2. Open SQL Query analyzer on the db server<BR /><BR />3. truncate the table dbo.notices (and some other tables i´ve found here in the Forum. sorry i dont know them anymore.)<BR /><BR />4. shrink the db file Wed, 01 Apr 2009 07:45:12 GMT https://community.hpe.com/t5/server-management-systems/sim-5-2-database-size/m-p/4387497#M36900 at2oo1 2009-04-01T07:45:12Z