• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1835
  • Last Modified:

Failed maintenance plan due to rebuild index

Over 300 tables are encountering the following error:

Executing the query "ALTER INDEX [PK_ModemList] ON [dbo].[ModemList] RE..." failed with the following error: "Online index operations can only be performed in Enterprise edition of SQL Server.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I searched on the microsoft website and found similar problems that were resolved by rebuilding indexes online: OFF. I applied the same solution as provided when runing STD version of SQL Server.  Unfortunately the solution did not work in my case.  

Here is my soluction and when executed the step failed again with the same error

Executing the query:
Alter Index [PK_ModemList] ON [dbo].[ModemList] REBUILD WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF)"



Please help with an alternative solution for Standard Version of SQL Server 2008 64bit edition
0
Favorable
Asked:
Favorable
  • 2
1 Solution
 
Rahul AgarwalTeam LeaderCommented:
0
 
FavorableAuthor Commented:
I have solved my own problem by using Ola Hallengren script.

Site info.
http://ola.hallengren.com/Documentation.html#GettingStarted
0
 
FavorableAuthor Commented:
I solved by using Ola Hallengren script.  Was very helpful.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now