<div>
<div class="content wysiwyg-content">
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).<br />
<br />
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?
</div>
</div>


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?

How to restore MASTER DB from 32-bit to 64-bit?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.