cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
zuku
Level 8
Report Inappropriate Content
Message 1 of 12

Database indexes are fragmented

Before upgrade EPO to version 5.9 I have warning massage:  ePo database indexes are fragmented. Rebuild the index before upgrading.

Could anyone give me instructions how to do that?

11 Replies
johnmoe
Level 11
Report Inappropriate Content
Message 2 of 12

Re: Database indexes are fragmented

There are instructions on how to do that in the SQL Maintenance Plan for ePO: https://kc.mcafee.com/corporate/index?page=content&id=kb67184

zuku
Level 8
Report Inappropriate Content
Message 3 of 12

Re: Database indexes are fragmented

Yes, but there is one problem, EPO installs with Microsoft SQL Server 2008 R2 Express version and SQL Management for Express edition des not have maintenance plans feature.

So I have to buy full version of SQL Server 2008 R2 to do this?

johnmoe
Level 11
Report Inappropriate Content
Message 4 of 12

Re: Database indexes are fragmented

I don't believe so, no, but it does mean you'll have to do it manually rather than through a maintenance plan.  I'm not a SQL expert, though, so I'm not entirely sure how one would go about it.  I believe MS's site has info about how to rebuild SQL indices; maybe you can adapt that for your SQL server using the info in the ePO SQL Maintenance Plan.

andrep1
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 5 of 12

Re: Database indexes are fragmented

You can install SQL server management studio and do the re-indexing from there.

Download SQL Server Management Studio (SSMS) | Microsoft Docs

Re: Database indexes are fragmented

I ran into the same issue - McAfee running on SQL Express.  I downloaded and installed Server Management Studio on the SQL server, then went to this link:

https://kc.mcafee.com/agent/index?page=content&id=KB67184&actp=null&viewlocale=en_US&showDraft=false...

Downloaded the RebuildReorganizeIndexes-V4.zip file, changed the .sql file to point to my database name then executed the script.  It fixed the problem so I could continue with the upgrade.

jswatts72
Level 7
Report Inappropriate Content
Message 7 of 12

Re: Database indexes are fragmented

When I ran into this issue I installed SQL Server Management Studio (you can use the SQL Server Disk or you can download).  You are correct, the Express Version does not have the ability to create a Management Task nor a SQL Server Agent job.  However, the easiest way to tackle this was to (in Studio) right click on your database and  create a query.  Take the entire contents of the file RebuildReorganizeIndexes-V4.sql (changing the EDITABLE entries as required) into the query window and execute it. 

epoope
Level 7
Report Inappropriate Content
Message 8 of 12

Re: Database indexes are fragmented

Hello, in my SQL Server Management Studio i have no "maintanance tasks" in Managements. Why i can´t create this ?sql Server.png

jswatts72
Level 7
Report Inappropriate Content
Message 9 of 12

Re: Database indexes are fragmented

You have the Express Version, to defragment you do not need the maintenance task, create the query and copy the RebuildReorganizeIndexes-V4.sql (change the EDITABLE) and execute.

epoope
Level 7
Report Inappropriate Content
Message 10 of 12

Re: Database indexes are fragmented

Thanks jswatts72 ! I don´t know how to do it. I have no experience in SQL. Did you know where i can find a manual or something about this job in SQL Express ?

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