from W2K3 32 bit to w2k8 64 bit

Last Post 10 Jan 2011 05:50 AM by rm. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
river1
New Member
New Member

--
08 Jan 2011 03:17 AM
Hi masters,

   I am thinking in migration the actual w2k3 32 bit servers that we have to w2k8 64 bits.

I think that all of the servers support 64 bits, since they are new servers ( 5 years the most).


But i don't know if i will have any problems....


My SQL Server licences are all to 32 bits.
My anti-virus are 32 bits


i want to migrate because the servers have 6 and more gigas of ram and we can not take advantage of this memory in 32 bit systems.


If i install sqlserver 2005 32 bit version on 64 bit w2k8 will the sql server see more memory then if it was installed on w2k3 32 bit?


what about other server application like anti-virus that i have in this servers? will i have any problems with them?

Thank you
gunneyk
New Member
New Member

--
08 Jan 2011 07:16 AM
A 32 bit app such as SQL Server can see and use up to 4GB of memory vs. 3GB using hte /3GB switch. But to use more than 4GB you still need AWE. But why would you install the 32 bit version if you will have the 64 bit OS? There is no license cost to go from 32 bit to 64 bit as the one license covers both. I would first check to ensure your servers can run x64 bit OS, especially if its 5 years old or even close. Anything over 2 or 3 years should be checked thouroughly first. As for the AV software you will probably need the 64 bit version but I am not 100% sure. I would check with the mfg and chances are the 64 bit version is probably free if you already have a 32 bit license as well.
river1
New Member
New Member

--
08 Jan 2011 08:25 AM
vs. 3GB using hte /3GB switch??? what is this (hte)

I want to install SQL Server 2005 32 bit because i don't know if there is any diffence between one version of SQL Server and the other. for example, can i install SQL Server 2005 64 bits on a server with W2k8 64 bits and them backup my databases that are on a server that uses SQL Server 2005 32 bits and restore them on the SQL Server 2005 that as 64 bits?

The client computers are in XP 32 bits with apps (vb apps) in 32 bits, they connect to SQL Server 2005, some through MDAC and others through SQLCNLI. will i have any problems if i change the the SQL Server from 32 bits to 64 bits?



Are there any differences between administring a SQL Server 2005 32 bits and a 64 bits? or is everything the same?

If i install SQL Server 2005 64 bits on a server that as w2k8 will SQL Server see all the available memory of the server? e.g 8 GB? or i still need the AWE?


Thank you
gunneyk
New Member
New Member

--
08 Jan 2011 09:35 AM
The (hte) was just a typo and it was simply supposed to be the word "the" . There is no difference in the database itself between 32 and 64 bit. You can backup & restore from one to the other or visa versa as long as the versions are the same. You many need new drivers on the server that are 64 bit but the clients should not know the difference. And yes on 64 bit even standard edition of SQL Server will see all the memory without AWE. In fact AWE is ignored in 64 bit SQL Server. But as always you should test first when ever possibe.
river1
New Member
New Member

--
08 Jan 2011 02:14 PM
what about SQL Server Management studio? is everything equal?


When you say that i may need new drivers to the server, you are talking about drivers for what? for the driver it self.


river1
New Member
New Member

--
08 Jan 2011 02:14 PM
what about SQL Server Management studio? is everything equal?


When you say that i may need new drivers to the server, you are talking about drivers for what? for the driver it self.


gunneyk
New Member
New Member

--
09 Jan 2011 04:32 AM
SSMS is the same. If you have any apps or SSIS packages that run directly on the server that access SQL Server they may need a 64 bit driver to connect.
river1
New Member
New Member

--
10 Jan 2011 01:24 AM
One more question about this issue:

Is SQL Server 2000, is there any 64 bits version? if yes, is it the same in terms of funcionalities as the 32 bits version?

Can i backup a database in SQL Server 2000 32 bits and restore it on SQL Server 2000 64 bits?

Thank you
russellb
New Member
New Member

--
10 Jan 2011 04:04 AM
There is no 64 bit version of SQL 2000
river1
New Member
New Member

--
10 Jan 2011 04:06 AM
ok, that means that in Servers where i have SQL Server 2000 installed, i do not gain any thing in upgrading the OS to 63 bits, right?
rm
New Member
New Member

--
10 Jan 2011 05:50 AM
No, may get worse in fact because it costs more to run 32-bit app under x64 OS.
You are not authorized to post a reply.

Acceptable Use Policy