CRM 4.0 Big Workflowbase table after Upgrade

[unknown]

We've upgraded CRM 3.0 to 4.0 and noticed that workflowbase table grew very big for only 4 workflow rules with 20 steps all together: 1.3G.
We back up database every day and space is an issue. Is there any safe way to shrink this table? Thanks a lot.


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 1
http://www.eggheadcafe.com/tutorials/aspnet/31ed1875-728d-4037-9074-4eba5c821311/wpf-report-engine-part-1.aspx

[Mercure Integration]

Maybe you should take a look at those articles...

http://support.microsoft.com/kb/974896
http://support.microsoft.com/kb/957871
__________________________________
Mercure Integration Support Team
http://www.mercureintegration.com

Post by unknown
We've upgraded CRM 3.0 to 4.0 and noticed that workflowbase table grew
very big for only 4 workflow rules with 20 steps all together: 1.3G.
We back up database every day and space is an issue. Is there any safe way
to shrink this table? Thanks a lot.
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 1
http://www.eggheadcafe.com/tutorials/aspnet/31ed1875-728d-4037-9074-4eba5c821311/wpf-report-engine-part-1.aspx

[David Vidmar]

There is a hotfix avaiable that is incorporated in latest Rollups, so wise
think to do would be to upgrage to latest rollup.

Then enable/check the registry entries Mercure postesd.

This link will provide T-SQL script which you should run in order to clean
up the table. Enabling the link will prevent new rows to appear.
--
Cheers, David
http://vidmar.net/weblog

Post by unknown
We've upgraded CRM 3.0 to 4.0 and noticed that workflowbase table grew very big for only 4 workflow rules with 20 steps all together: 1.3G.
We back up database every day and space is an issue. Is there any safe way to shrink this table? Thanks a lot.
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 1
http://www.eggheadcafe.com/tutorials/aspnet/31ed1875-728d-4037-9074-4eba5c821311/wpf-report-engine-part-1.aspx
.