epolicy database 1

[rev1322]

I noticed that my epolicy 3.0 database is taking up over 41 GIG of my disk space. I tried to clear out my events but they're still there. Is there an easy way to purge some or all of the unneccesary data?

 

[Yanze]

41 GIG ??? The database or the logfile?

If it's the logfile, try setting the database-mode to 'simple' in SQL Enterprise Manager ...

My DB is 25 MB and the log 5 MB ... for 500 clients.

 

[rev1322]

It's an ldf file. Can you tell me how to change the mode to simple or how to compress the database or reduce the size to recover any free space?

 

[Yanze]

Start - Programs - Microsoft SQL Server - Enterprise Manager

Expand the folders untill you see the database-folder.
Rightclick your ePO_DATABASE and choose Properties
Goto the Options-tab, under Recovery you can choose the recovery-model, i guess this is set to FULL instead of SIMPLE

At this tab, you can also set the AutoShrink-checkmark.

Under the DataFiles-tab you can set the AutoGrow-value (grow by 10%)

*****

If you want to manually shrink the database or logfile:

Rightclick your ePO_DATABASE, choose All Tasks - Shrink Database
Click the button Files... on the bottom of the window to shrink the files you want. Also you can see how much free space there is in each.

Another tip:

Rightclick your ePO_DATABASE, choose View - Taskpad
Now, when you leftclick the ePO_DATABASE you can quickly see some interesting stugff in the right-window!

 

[rev1322]

That fixed it. Thanks a lot for the help.

 

[theboyhope]

Helped me as well, mate. Cheers. Have a star. ;-)