Perry Whittle (5/7/2014)
Do you understand the ramifications of the below??winston Smith (5/7/2014)
Repair: Deleted off-row data column with ID 562825134080, for object ID 1076927654, index ID 1, partition ID 72057594039566336, alloc unit ID 72057594044153856 (type LOB data) on page (3:393971), slot 28.Repair: Deleted off-row data column with ID 562825199616, for object ID 1076927654, index ID 1, partition ID 72057594039566336, alloc unit ID 72057594044153856 (type LOB data) on page (3:393971), slot 29.
Repair: Deleted off-row data column with ID 562825265152, for object ID 1076927654, index ID 1, partition ID 72057594039566336, alloc unit ID 72057594044153856 (type LOB data) on page (3:393971), slot 30.
Congratulations you've just dropped Lords knows how much data from your database, was that your desired intention? Didn't you have a backup you could have restored?
I 100% completely understand what i did, i wouldn't have done it otherwise. And yes, I have a backup. The db only has 4 tables and is only for logging of agent data (not sql agent). I needed to get it online asap to prevent issues with agents/services/whatever you want to call them.