Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3483
  • 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
Building an Effective Phishing Protection Program

Join Director of Product Management Todd OBoyle on April 26th as he covers the key elements of a phishing protection program. Whether you’re an old hat at phishing education or considering starting a program -- we'll discuss critical components that should be in any program.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

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