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

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?
LVL 4
darth_wannabeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
in short: you cannot (restore), you will have to transfer the stuff you want to get copied over.
logins -> check out "transfer logins" on msdn.microsoft.com
msde -> jobs/dts/etc -> script out the jobs, save the dts to file, and use those on the destination server ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.