cancel
Showing results for 
Search instead for 
Did you mean: 

MSQL Express Database reached 4GB limit help!!

Hello,

Our MSQL 2005 Express database has reached it's 4Gb database   can we move it to another SQL server as we have a full SQL 2005 server?

If we can move it how can we tell ePolicy 4.5 where the new database is?

Thanks

6 Replies

Re: MSQL Express Database reached 4GB limit help!!

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

This Article will walk you through changing the necessary registry settings to get your database pointed to the right place.

Towards the bottom of the page is the section (section 7) that specifically answers your question.

Re: MSQL Express Database reached 4GB limit help!!

Thanks, this looks helpful.  For some reason though since the database has reached it's limit we can't login to the page https://1.2.3.4:8443 we use ldap authentication with our AD servers.  How can we get round this?

Re: MSQL Express Database reached 4GB limit help!!

Hi Gonzouk, I think you will need to free some space in your database bedore preceeding. You may also check that your HD isn't full or you won't get access to ePO.

You can't delete some space through OSQL commands:

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

Re: MSQL Express Database reached 4GB limit help!!

When I was administrating ePO w/ SQL Express, I would periodically go into the database and manually purge the event logging tables via queries to make space then compact the database to remove excess free space. If you are unsure how to use SQL queries, backup a SQL db or access the database, don't pass go & contact support for assitance.

You can purge the audit log periodically through the console if you remember to do it prior to hitting the size limit.  The only problem I found with my previous environment was that it would fail if I tried to purge more than 15-20 days at a time. 

Re: MSQL Express Database reached 4GB limit help!!

We managed to remove some old event logs fromthe DB, how can where can I use the ePolicy console to purge old data?

Re: MSQL Express Database reached 4GB limit help!!

In 4.5:

Automation -> Server Task Log

Change the display range w/ filter in upper left

Select rows

Action -> Purge

User Management -> Audit Log

Purge -> Define range to purge

on 6/28/11 8:23:31 AM CDT