Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Mcafee EPO Database Issue

Posted on 2010-11-24
11
3,239 Views
Last Modified: 2013-12-09
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
Comment
Question by:Ancients
  • 6
  • 5
11 Comments
 
LVL 4

Accepted Solution

by:
AimToPlease earned 500 total points
ID: 34211097
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
 
LVL 1

Author Comment

by:Ancients
ID: 34212039
THanks will give this ago tomorrow. Not sure about what is meant by instance though osql -E -S <servername\instance> -d ePO4_<databasename>

0
 
LVL 4

Expert Comment

by:AimToPlease
ID: 34212117
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 1

Author Comment

by:Ancients
ID: 34212214
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
 
LVL 1

Author Comment

by:Ancients
ID: 34212224
the epo4_svrname.mdf file size is 4194112KB and the epo_svrname_log.LDF is 768K

Still no go.
0
 
LVL 4

Expert Comment

by:AimToPlease
ID: 34212595
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
 
LVL 1

Author Comment

by:Ancients
ID: 34214850
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
 
LVL 4

Expert Comment

by:AimToPlease
ID: 34215732
Don't worry about it, we'll see how it goes.
0
 
LVL 1

Author Comment

by:Ancients
ID: 34234021
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
 
LVL 1

Author Closing Comment

by:Ancients
ID: 34234132
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
 
LVL 4

Expert Comment

by:AimToPlease
ID: 34234683

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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These are on the increase and getting more common these days. Users who use the Google search engine may complain of having their search redirected to unwanted sites, regardless of what browser is used. This happens when the system is infected with…
Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question