6 reputation
4
bio website rackattack.com
location Vancouver BC Canada
age 30
visits member for 4 months
seen Feb 25 at 19:22
stats profile views 4

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


Feb
25
revised Shrink database operation in maintenance plan failed
added 310 characters in body
Feb
20
revised Shrink database operation in maintenance plan failed
added 561 characters in body
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
awarded  Scholar
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
awarded  Student
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
revised Shrink database operation in maintenance plan failed
added 1378 characters in body
Jan
14
awarded  Editor
Jan
14
revised Shrink database operation in maintenance plan failed
added 559 characters in body
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.
Jan
14
asked Shrink database operation in maintenance plan failed
Jan
14
awarded  Autobiographer