troubleshooting Question

32-bit SQL Server 2000 Database to 64-bit 2008 server

Avatar of santaspores1
santaspores1Flag for United States of America asked on
Microsoft SQL Server 2008ASP.NET
3 Comments1 Solution319 ViewsLast Modified:
Hi,

I have a new server.  It acts as a web application server (asp.net) with an sql database back end.

The new server is 64-bit Windows Server 2008 R2 and I have installed 64-bit SQL Server 2008 R2.  I need to migrate databases that currently reside on a 32-bit Windows Server 2003 box running 32-bit SQL server 2000.  I plan on using the backup and restore method.  It looks like (from what I have read so far) I shouldn't encounter any real problems.  

I thought I would have to use transact SQL (specifying WITH MOVE) rather than a wizard because the data and log file paths on my new server will be different than on the old server - but it looks like the restore wizard on the 2008 box will move the files to the proper location rather than creating the old path from the old server.  It looks to me that the "resore the database file as" option takes care of that.  The defualt value there was:
C:\MyApps\SQL Server 2008 R2 64-bit\MSSQL10_50.MSSQLSERVER\MSSQL\Data\MyDatabaseName.MDF
Note that when I installed SQL server 2008 it wanted two paths - a 32-bit path (which defaulted to something like C:\Program Files\SQL Server (x86) ) and a 64-bit path (which defaulted to something like C:\Program Files\SQL Server)
It looks like the data files are being installed to the 64-bit path.

So Question 1 is:  Can I use the GUI as above to restore the database?  Does the "resore the database file as" location option take care of the "WITH MOVE" option (the WITH MOVE wording does not appear in the GUI Wizard as such)

Question 2 is: Also, when installing SQL server 2008 R2, it created TWO application paths - one for 32-bit and one for 64-bit.  The server management Studio is in the 32-bit path... is there not a 64-bit server management studio?

ASKER CERTIFIED SOLUTION
dba2dba

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros