I have a 32-bit Windows 2000 server running SQL Server 2000. There is a database running there that is a back end for an image archival program we use. I need to restore this database to a new 64-bit Windows Server 2003 machine, also running SQL 2000 (will upgrade to 2005 later).
I am able to restore the actual database no problem, but there are a bunch of user/security settings that I need as well. In the past, I have just restored the MASTER, MODEL databases to accomplish this (using 32-bit OS, etc). Now though, I get an error that the SQL versions do not match. I am assuming this is because I am trying to restore to a 64 bit server. Is there some way that I can accomplish this?