cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Dwee
Level 10
Report Inappropriate Content
Message 1 of 5

DB Server nearly full

Jump to solution

Hi team,

existing epo: 5.10 CU 10, SQL (forgot what version but it's not express edition), ePO on Cluster, 

Issue: DB server Disk space getting full,

Question : 1. how i can "somehow" getting back the space without add another network storage into the                         DB server,

                   2. can i delete the DB_EPO_Events_(XXXmonths) manually ? (ctrl+del), or there's any other                                  way to delete those monthly DB_EPO_Events_(monthlies) ?

                   3.  also can i delete the FUll backup.BAK file if i already copy or upload that file beforehand ?

see the screenshot for details

1 Solution

Accepted Solutions
aguevara
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 5

Re: DB Server nearly full

Jump to solution

the databases shouldnt be deleted manually, if events are the culprit for the size of your DB then we have 2 articles explaining how to safely delete events from the DB:

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

or

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

you can even delete all contents of those months by modifying the dates if needed but the articles above are the safest way

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

4 Replies
aguevara
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 5

Re: DB Server nearly full

Jump to solution

1. It really depends what your SQL team has in place for your SQL, we have an article explaining the recommended maintenance plan and that also talks about the recovery model, i assume it is currently on full recovery model, if it is i would suggest you to look at the article below and see if your organization could implement a simple recovery model, this article is for registered users:

https://kc.mcafee.com/agent/index?page=content&id=KB67184

2. We don't recommend the manual deletion of those Months, instead i can suggest you to first understand why the DB is full using this article: 

https://kc.mcafee.com/agent/index?page=content&id=KB85506

if events are the culprit for your the size of your DB then we have 2 articles explaining how to safely delete events from the DB:

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

or

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

3. Yes those back ups are stored on a default SQL installation path, you can delete them after ensuring you have stored them safely in case you need to restore the DB (ensure you have matching ePO system files for those back ups for a successful restore)

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Dwee
Level 10
Report Inappropriate Content
Message 3 of 5

Re: DB Server nearly full

Jump to solution

Hi Aguevara,

 

we just want to know is there any other way to save disk space on our DB server, and for the purging task we already do that, and when we look that theres monthly events DB (that earlier i pointed) especially last year events, we thought that we can delete that manually because they have good space used to freed,

 

 

aguevara
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 5

Re: DB Server nearly full

Jump to solution

the databases shouldnt be deleted manually, if events are the culprit for the size of your DB then we have 2 articles explaining how to safely delete events from the DB:

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

or

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

you can even delete all contents of those months by modifying the dates if needed but the articles above are the safest way

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 5

Re: DB Server nearly full

Jump to solution

You can't delete the database files themselves, or you will definitely break things.  Purging those events is the way to go.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community