• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3439
  • Last Modified:

Mcafee EPO Database Issue

HI,

I have a Mcafee EPO 4 that has a DB which has now reached 4.1GB. the limit from what I understand.

how can i make this smaller. step by step instructions appreciated. as I am not as familiar with this version as with previous versions.
thanks

AJ
0
Ancients
Asked:
Ancients
  • 6
  • 5
1 Solution
 
AimToPleaseCommented:
This link will help you manually delete old events from the ePO Database:

https://kc.mcafee.com/corporate/index?page=content&id=KB53549

Remember to replace the dd/mm/yyyy part with the actual date (the more recent this date, the more events you'll remove from the DB).

Then, cycle McAfee ePolicy Orchestrator Application Server service. Log in to ePO and create a Server Task of the typer Purge Events to automatically purge old events.
0
 
AncientsAuthor Commented:
THanks will give this ago tomorrow. Not sure about what is meant by instance though osql -E -S <servername\instance> -d ePO4_<databasename>

0
 
AimToPleaseCommented:
This is the MS SQL Instance name. When using SQL Express, this is usually SERVERNAME\EPOSERVER. The database name is usually EPO4_SERVERNAME

Hope this helps..
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
AncientsAuthor Commented:
thanks AimtoPlease, I have figured it out and am trying the instructions. and they seem to work. but the db has not shrunk or anything. have also restarted both the SQL EPO services.

any ideas? seen this before?

AJ
0
 
AncientsAuthor Commented:
the epo4_svrname.mdf file size is 4194112KB and the epo_svrname_log.LDF is 768K

Still no go.
0
 
AimToPleaseCommented:
The LDF is your transaction log. No fun there.

You could try to download Microsoft SQL Server Management Studio Express from here:

http://www.google.nl/url?sa=t&source=web&cd=1&ved=0CBkQFjAA&url=http%3A%2F%2Fwww.microsoft.com%2Fdownloads%2Fdetails.aspx%3FFamilyId%3DC243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&ei=n23uTN78Cc_oOcyTlIUK&usg=AFQjCNG4p99GpP181e4C4-HcvHLLOJ9ZDg&sig2=flDlCEejBmR6d-M9x86yQg

After installing it, try to shrink the database using that tool. It should at least help you determine which table in your database takes up the most space. Connect to the database, then proceed to Databases -> EPO4_SERVERNAME -> Right-click -> Task -> Shrink -> Database

This will tell you how much space would be freed.

You can do the same on the file level if you go to Databases -> EPO4_SERVERNAME -> Right-click -> Task -> Shrink -> files

If you expand Tables and right click dbo.ePOEvents to select its properties, it will tell you how much space is used for events... this might clue you in if the above doesn't work... :)
0
 
AncientsAuthor Commented:
Thanks AimToPlease,

I will give this ago later today and let you know how it goes. really appreciate your time and effort.

Thanks

AJ
0
 
AimToPleaseCommented:
Don't worry about it, we'll see how it goes.
0
 
AncientsAuthor Commented:
You are a genius. I went in now to make the changes you mentioned, and the DB was down to 91MB... must have needed a bit of time to shrink after the command line entries.

I have also done the DB file shrink and it gave me another 20 odd MBs. so that has seen us down quiet significantly from 4.1GB's

AJ
0
 
AncientsAuthor Commented:
Excellent Advise and the instructions very clear. The support the way Experts should be!

We have had many techs and consultants look into this with no luck! So, very much appreciated for all your help!

Thanks AimToPlease!

very pleased indeed :)

AJ
0
 
AimToPleaseCommented:

So it is resolved. good! :) Glad I could help.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now