Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

32 bit SQL 2005 database on 64 bit O/S?

Posted on 2008-10-13
1
Medium Priority
?
184 Views
Last Modified: 2012-05-05
I have a server running SQL 2000 on a Windows Server 2003, 32 bit platform.  I have plans on upgrading this database to SQL 2005.

I have a server running Windows Server 2008, 64 bit platform.  Can I move my newly upgraded SQL 2005 database to my 64 bit server?  
0
Comment
Question by:sknoll84
1 Comment
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 1000 total points
ID: 22708663
Yes.  User databases created on 32 bit versions can be moved to 64 bit and vice versa.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Loops Section Overview

972 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