16 reputation
5
bio website rackattack.com
location Vancouver BC Canada
age 31
visits member for 1 year, 3 months
seen Apr 2 at 17:25

System Developer / Administrator at Rack Attack LLP. http://www.rackattack.com


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.