Upgrading SQL2005 32 bit to SQL2005 64 bit

Last Post 06 Jul 2010 04:22 AM by rm. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ctseah
New Member
New Member

--
28 Jun 2010 09:46 PM

Hi,

I have a machine windows 2003 server 64 bits, currently the sql 2005 server database installed is a 32 bit.

I am pondering to upgrade it to sql 2005 64 bits. Is it advisable to upgrade to sql 2005 64 bits ?

I wonder whether such upgrade is better to be done using (method 1)In-Placed  or (method 2) Install another sql 2005 64 bit on the same machine and then do a migration of the 32 bit databases to 64 bit databases ?

For (method 2) can I do a backup and restore method of migrating all the User databases and the System Databases or should I do a deattach and attach method ?

Thanks in advance for your time in answering my query.
Regards

rm
New Member
New Member

--
29 Jun 2010 03:12 AM
I prefer to have separate 64-bit instance, you can backup dbs in 32-bit instance then restore to 64-bit instance. Can copy sql logins and jobs with ssis tasks.
ctseah
New Member
New Member

--
29 Jun 2010 04:31 PM
Hi rm,

Thanks, I just realised that there will be a new 64 machine which will be named as the original machine.
This new machine will be installed with SQL2005 64 bits. However these two machine will be on separate VLAN.
Can I still using using ssis tasks to copy sql logins and jobs to accomplish my tasks ?

I am not familiar with ssis tasks, any link to documentation ?

Thanks in advance.
rm
New Member
New Member

--
30 Jun 2010 06:01 AM
Can use ssis as long as those servers can talk to each other, books online has details of ssis.
ctseah
New Member
New Member

--
30 Jun 2010 05:15 PM

Hi rm,

I read somewhere on the website that for this upgrade of sql 2005 32 bit to sql 2005 64 bit, I can do a backup and restore. This method you also mentioned, but how about the system databases ? Can I also do backup and restore method to upgrade them to 64 bits ?

Please advise.

Thank you.

rm
New Member
New Member

--
01 Jul 2010 05:20 AM
Yes you can, ensure both instances have same build number and file path of master db.
ctseah
New Member
New Member

--
01 Jul 2010 05:23 PM

Hi rm,

Same build : ok understood

Same path : not very sure what you mean, can give an example ?

 

Thanks

ctseah
New Member
New Member

--
06 Jul 2010 12:28 AM

Hi rm,

Can elaborate a bit more on "file path of master db" ?

thanks & Regards
rm
New Member
New Member

--
06 Jul 2010 04:22 AM
Sql has startup parameters for master db location (file path), it will not start if master db files are in wrong location.
You are not authorized to post a reply.

Acceptable Use Policy