Reputation
Top tag
Next privilege 20 Rep.
Talk in chat
Badges
1 5
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Feb
20
comment Shrink database operation in maintenance plan failed
Shrink DB removed. Still hanging. rebuild index is the problem. 2 of the MANY operation in that sub task: USE [RackAttackNorthAmerica] GO ALTER INDEX [childCategories] ON [dbo].[category] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF ) GO USE [RackAttackNorthAmerica] GO ALTER INDEX [mfgID] ON [dbo].[category] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, ONLINE = OFF, SORT_IN_TEMPDB = OFF ) GO
Jan
15
comment Shrink database operation in maintenance plan failed
Thank you very much for the info.
Jan
15
comment Shrink database operation in maintenance plan failed
Awesome, thanks for the input.
Jan
14
comment Shrink database operation in maintenance plan failed
@ Ali Razeghi: Did you want me to run the maintenance plan and then pull that data? or is it fine as is?
Jan
14
comment Shrink database operation in maintenance plan failed
No, that's what I'm trying to figure out. I've received "failed task" notifications from a variety of tasks.