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
LVL 1
AncientsAsked:
Who is Participating?
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.

All Courses

From novice to tech pro — start learning today.