Spam Filter ISP Forums : Best way to move from MS 2000 to 2005 https://www.logsat.com/spamfilter/forums/ Wed, 15 Apr 2026 16:14:51 +0000 Wed, 05 Sep 2007 01:25:57 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6226 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Best way to move from MS 2000 to 2005 : I used the 2005 Copy Wizard tocreate...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226&PID=10865&title=best-way-to-move-from-ms-2000-to-2005#10865 Author: WebGuyz
Subject: 6226
Posted: 05 September 2007 at 1:25am

I used the 2005 Copy Wizard to create the database and move the data, but in retrospect I should have done a detach/attach. Will try that this weekend.
 
Thanks!
]]> Wed, 05 Sep 2007 01:25:57 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226&PID=10865&title=best-way-to-move-from-ms-2000-to-2005#10865 <![CDATA[Best way to move from MS 2000 to 2005 : The compatibility mode should...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226&PID=10863&title=best-way-to-move-from-ms-2000-to-2005#10863 Author: LogSat
Subject: 6226
Posted: 04 September 2007 at 11:43pm

The compatibility mode should not be an issue, SpamFilter will work in 2005 compatibility mode.

Could you instead please verify and ensure that when you migrated the database, on the new database the column "msgid" in the table tblMsgs has still been configured to be an "Identity" column, meaning that SQL Server will assigning the values for that column?

If that column was not of the "Identity" type, something has gone wrong in your migration, and you'll want to re-check everything as other problems may have occurred.
]]> Tue, 04 Sep 2007 23:43:27 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226&PID=10863&title=best-way-to-move-from-ms-2000-to-2005#10863 <![CDATA[Best way to move from MS 2000 to 2005 : I tried to upgrade to 2005 this...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226&PID=10856&title=best-way-to-move-from-ms-2000-to-2005#10856 Author: WebGuyz
Subject: 6226
Posted: 03 September 2007 at 7:41am

I tried to upgrade to 2005 this early morning and started getting these errors on the new database;
 
09/03/07 05:50:04:859 -- (6568) Error occurred during TAddToQuarantineThread when accessing the quarantine database: Cannot insert the value NULL into column 'MsgID', table 'spamfilter.dbo.tblMsgs'; column does not allow nulls. INSERT fails ( 83 84 85 86 86a 86b 86c 87 88 89 90 91)
 
I stopped all the SFE's and then used the 2005 wizard to copy the db from MS 2000 where it works fine. I set the compatability mode to 2000 but not sure if its dynamic or not since I changed that option while it was running.
 
Put everything back for now. Is there a recommened best practice for upgrading SFE to MS SQL 2005?
 
Thanks!!
]]> Mon, 03 Sep 2007 07:41:59 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6226&PID=10856&title=best-way-to-move-from-ms-2000-to-2005#10856