Undeploy Error in BizTalk Explorer

I was clueless when I got this error when I undeploy the assembly using BizTalk Explorer or using WMI script.

SQL exception: I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x00000000630000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\BizTalkMgmtDb.mdf'.

Finally got the UnDeploy done in SQL way. Just run the below sql script in your Biztalk DB and delete your assembly from GAC manually.

-------------------
use BiztalkMgmtDB
go
declare @iAssemblyID int
select @iAssemblyID=nID from bts_assembly where nvcName = 'yourAssemblyName'
delete from bt_mapspec where assemblyid = @iAssemblyID
delete from bt_documentspec where assemblyid = @iAssemblyID
delete from bts_item where assemblyid = @iAssemblyID
delete from bt_properties where nassemblyid = @iAssemblyID
delete from bt_sensitiveproperties where assemblyid = @iAssemblyID
delete from bts_assembly where nID = @iAssemblyID
--------------------

..... and finally

Welcome to my blog. The goal of this site is to share some of my BizTalk development experiences with you all. You can find useful tips, code snippets and other useful articles in my blog. Please feel free to add comments on my blogs.

Oh.. How can my first blog be without any techie additions.... here you go..

Windows XP SP2 can be pushed to 'Automatic Update' anytime soon... ready to install these hot fixes if you have BizTalk2004 on your machines....

1) BizTalk Server 2004 will stop functioning after the installation ofWindows XP SP2 due to changes in the DCOM security model. Windows XP SP2 isavailable for download now and will be pushed through WindowsUpdate in lateAugust.Modify the registry with the instructions below to resolve this issue:http://support.microsoft.com/default.aspx?scid=kb;en-us;841893

2) The BizTalk Server 2004 Rules Engine component will stop functioning after the installation of the .NET FW 1.1 SP1 (is part of WindowsXP SP2) due to issues in ourimplementation. It is expected that all other existing user-level codewritten in the .NET FW 1.1 will continue to work in the .NET FW 1.1 SP1.The .NET Framework 1.1 SP1 is not yet publically available but will becomeavailable shortly.Download the hotfix for the rules engine component to resolve this issue:http://support.microsoft.com/default.aspx?scid=KB;EN-US;875540

N.B. This hotfix is supported both on the .NET FW 1.1 and the .NET FW 1.1SP1 so you can install it today if you like.