?
Solved

Mcafee EPO Database Issue

Posted on 2010-11-24
11
Medium Priority
?
3,332 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
[X]
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
  • 6
  • 5
11 Comments
 
LVL 4

Accepted Solution

by:
AimToPlease earned 2000 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Cyber Threats to Small Businesses (Part 2)

The evolving cybersecurity landscape presents SMBs with a host of new threats to their clients, their data, and their bottom line. In part 2 of this blog series, learn three quick processes Webroot’s CISO, Gary Hayslip, recommends to help small businesses beat modern threats.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article investigates the question of whether a computer can really be cleaned once it has been infected, and what the best ways of cleaning a computer might be (in this author's opinion).
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 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