Client Management Suite

So it appears that I've been bitten by the bug listed in TECH140985.

http://www.symantec.com/business/support/index?page=content&id=TECH140985

I ran the suggested fix and all is good, I guess.  However, that table is still like 80GB.  How can I effectively clean out this table?

Additionally, I've got like an 8GB log file.  I read the KB article HOWTO1752 (linked below) regarding the log file.  I did everything listed with a few moditications for SQL Server 2008.  However, the file remains the same size.

http://www.symantec.com/business/support/index?page=content&id=HOWTO1752

(By the way, this article needs to be updated since SQL Server 2008 doesn't support the 'TRUNCATE_ONLY' parameter mentioned).

Suggestions?

Update: I did get the log file shrunk.  I had forgotten to shrink the ACTUAL file.

Hello Zac,

The KB article only takes care of removing the schedule tasks from the NS. The SQL changes is needed because if you only delete the task from '%windir%\tasks' it gets recreated by the weekly schedule task.

Now, before you run any truncation, the big question is: do you need any of the data in the table?

If the answer is no, go ahead and truncate it.

If not, you'll want to delete large chunks of it without running SQL that will take forever (check if there's an index on the table that can be used, like a modified date or positional value).

Let us know if you need more details on either case!

Im not sure whats in that table, but I can't imagine that I need 90GB of it.  I'm fine with removing/reducing it.

I'm no SQL guru.  Suggestions on how to remove this data?

Do you have a test system available?

Go and truncate the table there to see if it helps without any side impact.

Given this is a history table it should be safe for clearing, but you better check with your support contacts ;).

Whew!  My DB is now a much more manageable 11GB.  Thanks for your help.  I'll close my support ticket now too.