Solved

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

Posted on 2008-10-13
1
174 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 250 total points
ID: 22708663
Yes.  User databases created on 32 bit versions can be moved to 64 bit and vice versa.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the best way to calculate hours worked 5 61
Why do I get extra rows when I do inner join? 12 38
SQL Agent Timeout 5 47
Passing value to a stored procedure 8 91
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

910 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