Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Database is 58GB. How do I decrease size?

Josh Robinson
Occasional Contributor

Database is 58GB. How do I decrease size?

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.
3 REPLIES
Preston Gallwas
Valued Contributor

Re: Database is 58GB. How do I decrease size?

You should be able to delete any old/unneeded events then do database maint using sql enterprise manager...

If you're using MSDE I am unsure of the tool you'll need to do the maintence
Bill Slobodnik
Frequent Advisor

Re: Database is 58GB. How do I decrease size?

If you're using MS SQL, then make sure the recovery model is set to simple.
Igor Karasik
Honored Contributor

Re: Database is 58GB. How do I decrease size?

Most likely your have large transaction log, you need to shrink the transaction log file and change to simple recovery model
See
http://support.microsoft.com/kb/873235/en-us