Zack
asked on
Index Rebuild Job suddenly started failing
Heyas,
My maintenance plan for rebuilding indexes has started to fail below is the error message:
.Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:00:00 PM Progress: 2016-08-02 21:00:02.84 Source: {6DFF2819-4B44-4B9D-8F99-A 687CCB094A C} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2016-08-02 21:05:37.50 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 0% complete End Progress Progress: 2016-08-02 21:05:37.51 Source: Rebuild Index Executing query "ALTER INDEX [ABSENCES] ON [dbo].[ABSENCES] REBUILD...".: 0% complete End Progress Progress: 2016-08-02 21:05:37.51 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 0% complete End Progress Progress: 2016-08-02 21:05:37.51 Source: Rebuild Index Executing query "ALTER INDEX [ABSENCES_ID] ON [dbo].[ABSENCES] REBU...".: 0% complete End Progress Progress: 2016-08-02 21:05:37.51 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 0% complete End Progress Progress: 2016-08-02 21:05:37.51 Source: Rebuild Index Executing query "ALTER INDEX [ABSENCES2] ON [dbo].[ABSENCES] REBUIL...".: 0% complete End Progress Progress: 2016-08-02 21:05:37.51 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 0% complete End Progress Progress: 2016-08-02 21:05:37.52 Source: Rebuild Index Executing query "ALTER INDEX [ABSENCES3] ON [dbo].[ABSENCES] REBUIL...".: 0% complete End Progress Progress: 2016-08-02 21:05:37.52 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 0% complete End Progress Progress: 2016-08-02 21:05:37.52 Source: Rebuild Index Executing query "ALTER INDEX [ACCOUNT_NDX1] ON [dbo].[ACCOUNT] REBU...".: 0% complete End Progress Progress: 2016-08-02 21:05:37.52 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 1% complete End Progress Progress: 2016-08-02 21:05:37.52 Source: Rebuild Index Executing query "ALTER INDEX [ACCOUNT_NDX2] ON [dbo].[ACCOUNT] REBU...".: 1% complete End Progress Progress: 2016-08-02 21:05:37.52 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 1% complete End Progress Progress: 2016-08-02 21:05:37.53 Source: Rebuild Index Executing query "ALTER INDEX [PK_ACCOUNT] ON [dbo].[ACCOUNT] REBUIL...".: 1% complete End Progress Progress: 2016-08-02 21:05:37.53 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 1% complete End Progress Progress: 2016-08-02 21:05:37.55 Source: Rebuild Index Executing query "ALTER INDEX [PK_ACTIVATION] ON [dbo].[ACTIVATION] ...".: 1% complete End Progress Progress: 2016-08-02 21:05:37.55 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 1% complete End Progress Progress: 2016-08-02 21:05:37.56 Source: Rebuild Index Executing query "ALTER INDEX [PK_ACTIVITY_POLE] ON [dbo].[ACTIVITY_...".: 1% complete End Progress Progress: 2016-08-02 21:05:37.56 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 1% complete End Progress Progress: 2016-08-02 21:05:37.56 Source: Rebuild Index Executing query "ALTER INDEX [POLE_NDX1] ON [dbo].[ACTIVITY_POLE] R...".: 1% complete End Progress Progress: 2016-08-02 21:05:37.56 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 1% complete End Progress Progress: 2016-08-02 21:05:37.56 Source: Rebuild Index Executing query "ALTER INDEX [POLE_NDX2] ON [dbo].[ACTIVITY_POLE] R...".: 2% complete End Progress Progress: 2016-08-02 21:05:37.56 Source: Rebuild Index Executing query "USE [AssetPlus] ".: 2% complete End Progress Progress: 2016-08-02 21:05:37.57 Source: Rebuild Index Executing query "ALTER INDEX [POLE_NDX3] ON [dbo].[ACTIVITY_POLE] R...".: 2% complete End Progress Progress: 2016-08-02 21:05:37.57 Source: Rebuild Index Executin... The package execution fa... The step failed.
The indexes that are having issues are:
ALTER INDEX [ABSENCES]
ALTER INDEX [ABSENCES2]
ALTER INDEX [ABSENCES3]
ALTER INDEX [ACCOUNT_NDX1]
ALTER INDEX [ACCOUNT_NDX2]
ALTER INDEX [PK_ACCOUNT]
ALTER INDEX [PK_ACTIVITY_POLE]
ALTER INDEX [PK_ACTIVATION]
ALTER INDEX [POLE_NDX1]
ALTER INDEX [POLE_NDX2]
ALTER INDEX [POLE_NDX3]
Troubleshooting so far:
- I have run dbcc checkdb no issues.
- My log file is under <1GB
- Log file is set to grow 10% every time.
How do I begin to troubleshoot this issue?
Any assistance is appreciated.
I am running SQL Server 2008 R2 Enterprise. also I keep my index online whilst reindexing.
Thank you.
My maintenance plan for rebuilding indexes has started to fail below is the error message:
.Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 9:00:00 PM Progress: 2016-08-02 21:00:02.84 Source: {6DFF2819-4B44-4B9D-8F99-A
The indexes that are having issues are:
ALTER INDEX [ABSENCES]
ALTER INDEX [ABSENCES2]
ALTER INDEX [ABSENCES3]
ALTER INDEX [ACCOUNT_NDX1]
ALTER INDEX [ACCOUNT_NDX2]
ALTER INDEX [PK_ACCOUNT]
ALTER INDEX [PK_ACTIVITY_POLE]
ALTER INDEX [PK_ACTIVATION]
ALTER INDEX [POLE_NDX1]
ALTER INDEX [POLE_NDX2]
ALTER INDEX [POLE_NDX3]
Troubleshooting so far:
- I have run dbcc checkdb no issues.
- My log file is under <1GB
- Log file is set to grow 10% every time.
How do I begin to troubleshoot this issue?
Any assistance is appreciated.
I am running SQL Server 2008 R2 Enterprise. also I keep my index online whilst reindexing.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry meant to attach the error log last night, worked it out taking the DB offline and online fixed the issue.