• dba_neo (2/1/2010)


    Team,

    My Rebuild,Reorganize index job has been failing because of the following error,it is scheduled to be executed in only one db and the db is in simple mode.

    ON [my].[User] REBUILD [SQLSTATE 01000] (Message 0) Executed: ALTER INDEX [IX_myUser_UserID] ON [my].[User] REBUILD [SQLSTATE 01000] (Message 0) Executed: ALTER INDEX [IX_EmPID] ON [EMPSs].[EMP] REORGANIZE [SQLSTATE 01000] (Message 0) Executed: ALTER INDEX [idx_TypeID] ON [EMPs].[EMP] REORGANIZE [SQLSTATE 01000] (Message 0) Executed: ALTER INDEX [IX_Files] ON [dbo].[Unload] REBUILD [SQLSTATE 01000] (Message 0) Executed: ALTER INDEX [IX_CardID] ON [Card].[Time] REBUILD [SQLSTATE 01000] (Message 0) Executed: ALTER INDEX [PK_PowerID] ON [dbo].[Power] REBUILD [SQLSTATE 01000] (Message 0) Executed: ALT... The step failed.

    Did you try to run it from SQL Manage Studio manually out of the job? I will give you more specific error message if any...