Solved

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

Posted on 2008-10-06
2
496 Views
Last Modified: 2009-05-29
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?
0
Comment
Question by:darth_wannabe
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server RDS clr assembly 4 34
Ranking Based On Value 3 28
Date conversion in sql server 2012 6 25
Report Builder 9 25
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now