https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764434#M19478 I will start out by saying I have no experience with SIM. It was installed on our server before my arrival and the database has reached 58GB. How do I shrink this database? This is SIM version 4.1 with SP1. Any help is greatly appreciated. Mon, 03 Apr 2006 08:38:10 GMT Josh Robinson 2006-04-03T08:38:10Z https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764434#M19478 I will start out by saying I have no experience with SIM. It was installed on our server before my arrival and the database has reached 58GB. How do I shrink this database? This is SIM version 4.1 with SP1. Any help is greatly appreciated. Mon, 03 Apr 2006 08:38:10 GMT https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764434#M19478 Josh Robinson 2006-04-03T08:38:10Z https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764435#M19479 You should be able to delete any old/unneeded events then do database maint using sql enterprise manager...<BR /><BR />If you're using MSDE I am unsure of the tool you'll need to do the maintence<BR /> Mon, 03 Apr 2006 11:55:57 GMT https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764435#M19479 Preston Gallwas 2006-04-03T11:55:57Z https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764436#M19480 If you're using MS SQL, then make sure the recovery model is set to simple. Mon, 03 Apr 2006 14:59:12 GMT https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764436#M19480 Bill Slobodnik 2006-04-03T14:59:12Z https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764437#M19481 Most likely your have large transaction log, you need to shrink the transaction log file and change to simple recovery model<BR />See <BR /><A href="http://support.microsoft.com/kb/873235/en-us" target="_blank">http://support.microsoft.com/kb/873235/en-us</A><BR /> Mon, 03 Apr 2006 15:29:33 GMT https://community.hpe.com/t5/server-management-systems/database-is-58gb-how-do-i-decrease-size/m-p/3764437#M19481 Igor Karasik 2006-04-03T15:29:33Z