Heavy load of SQL Database

[Mark Güthling]

Hi there,
I installed the actual HP Insight Manager a few weeks ago. Only 2 Discovery runs has taken place. But the DB on our MS Exchange consists of aprox. 23 GB of data. Can I clear the DB in any way? Or is it possible to reduce the amount of collected data?

Thanks,

Mark

[jim goodman]

Did you mean to ask about the Exchange Database or the Insight Database and Transaction Logs?

- Jim

[Mark Güthling]

I talk about the insight DB on our SQL Server.

Mark

[jim goodman · Accepted solution]

Some folks are changing the recovery mode to simple and checking Auto Shrink. Then perform a backup and the file should shrink considerably. I haven't done it yet but many folks here have stated this has worked for them.

- Jim