cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

Hello,

we want to upgrade our ePolicy server to version 5.9.

After some issues the Upgrade fail with the error message: The SQL database needs more free space or setup will fail.

It needs two times the current database size to continue.

We use a 2008 R2 SQL Express and the database only have 500 MB free disk Space 😳!

I think thats to much for 400 clients...

We run the purge tasks and finally found that kb: https://kc.mcafee.com/corporate/index?page=content&id=KB79561&pmv=print&glossary=true

I´m not sure if it´s the right way...

My question is do anyone has a other solution or had the same problem?

 

 

 

2 Solutions

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

Re: Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

To truncate snapshot table, you can use #: truncate table Orionsnapshot

 

 

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?please select Accept as Solution in my reply and together we can help other members?
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 5 of 5

Re: Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

delete from orionshanpshot

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?

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

Re: Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

One thing to check is to make sure you aren't running the snapshot disaster recovery task.  That will fill up an Express database.  You can check the orionsnapshot table to make sure there isn't anything in it.  If there is, you can truncate it by using this script:

delete from orionshanpshot

otherwise you might want to check which tables are taking up the room.  KB85506 has info on that.  Keep in mind, only events and the snapshot table can be purged safely.

 

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?

Highlighted

Re: Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

Thank you so much!

You've got me on the right track 👍

Could you post the script or link to the script. I´t dos´nt work.

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

Re: Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

To truncate snapshot table, you can use #: truncate table Orionsnapshot

 

 

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?please select Accept as Solution in my reply and together we can help other members?
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 5 of 5

Re: Upgrade ePol 5.3.1 to 5.9 SQL Free Disk Space

Jump to solution

delete from orionshanpshot

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?

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator