64-bit versus 32-bit

Is there a difference in SQL Server 2005 64-bit versus 32-bit from a
development or management point? I realize that there are differences in
the hardware requirements and that there is 32-bit, X64, and IA64 versions.
I wanted to know if sp's, back-ups, data types, queries and functions all
work and act the same.Hi,
There is no difference interms of development..The major differnece is in
handling the memory.
see this link to get the capacity specs for 32 and 64 bits:-
http://msdn2.microsoft.com/en-us/library/ms143432.aspx
Thanks
Hari
SQL Server MVP
"Chris Ruggiero" <chris.ruggiero@.gaboing.com> wrote in message
news:edDAV1qxGHA.3500@.TK2MSFTNGP02.phx.gbl...
> Is there a difference in SQL Server 2005 64-bit versus 32-bit from a
> development or management point? I realize that there are differences in
> the hardware requirements and that there is 32-bit, X64, and IA64
> versions. I wanted to know if sp's, back-ups, data types, queries and
> functions all work and act the same.
>|||Hi,
I'm new to SQL so any guidance is appreciated.
We have 3 MS SQL based applications currently running on SBS 2003 Premium.
As the data has grown so much, we will be purchasing a new server dedicated
to SQL alone. The new server will be 64 bit capable (Xeons not Itaniums).
Not understanding the mechanics of it all, my question is this :-
Will the current SQL databases run without modification if we purchased the
new server with 64bit Windows Server 2003 and 64bit SQL Server 2005 or are
32bit SQL databases not compatible with the 64bit SQL Server ?
and
If forced to, will the database (or SQL itself) run properly if we put in 64
bit Windows Server 2003 and 32 bit SQL Server 2005 ?
Thanks.
Kelvin
"Hari Prasad" wrote:
> Hi,
> There is no difference interms of development..The major differnece is in
> handling the memory.
> see this link to get the capacity specs for 32 and 64 bits:-
> http://msdn2.microsoft.com/en-us/library/ms143432.aspx
> Thanks
> Hari
> SQL Server MVP
> "Chris Ruggiero" <chris.ruggiero@.gaboing.com> wrote in message
> news:edDAV1qxGHA.3500@.TK2MSFTNGP02.phx.gbl...
> > Is there a difference in SQL Server 2005 64-bit versus 32-bit from a
> > development or management point? I realize that there are differences in
> > the hardware requirements and that there is 32-bit, X64, and IA64
> > versions. I wanted to know if sp's, back-ups, data types, queries and
> > functions all work and act the same.
> >
>
>|||The database format is the same for 32 and 64 bit SQL Server. So you can both restore and attach a
database from 32 bit to 64 bit.
You can also run 32 bit SQL Server engine on 64 bit OS if x64. But I recommend pure 64 bit, of
course.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kelvin" <Kelvin@.discussions.microsoft.com> wrote in message
news:8A8F125A-CA70-4312-93B3-E2ECAE0F7F44@.microsoft.com...
> Hi,
> I'm new to SQL so any guidance is appreciated.
> We have 3 MS SQL based applications currently running on SBS 2003 Premium.
> As the data has grown so much, we will be purchasing a new server dedicated
> to SQL alone. The new server will be 64 bit capable (Xeons not Itaniums).
> Not understanding the mechanics of it all, my question is this :-
> Will the current SQL databases run without modification if we purchased the
> new server with 64bit Windows Server 2003 and 64bit SQL Server 2005 or are
> 32bit SQL databases not compatible with the 64bit SQL Server ?
> and
> If forced to, will the database (or SQL itself) run properly if we put in 64
> bit Windows Server 2003 and 32 bit SQL Server 2005 ?
> Thanks.
> Kelvin
> "Hari Prasad" wrote:
>> Hi,
>> There is no difference interms of development..The major differnece is in
>> handling the memory.
>> see this link to get the capacity specs for 32 and 64 bits:-
>> http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>> Thanks
>> Hari
>> SQL Server MVP
>> "Chris Ruggiero" <chris.ruggiero@.gaboing.com> wrote in message
>> news:edDAV1qxGHA.3500@.TK2MSFTNGP02.phx.gbl...
>> > Is there a difference in SQL Server 2005 64-bit versus 32-bit from a
>> > development or management point? I realize that there are differences in
>> > the hardware requirements and that there is 32-bit, X64, and IA64
>> > versions. I wanted to know if sp's, back-ups, data types, queries and
>> > functions all work and act the same.
>> >
>>|||"Kelvin" <Kelvin@.discussions.microsoft.com> wrote in message
news:8A8F125A-CA70-4312-93B3-E2ECAE0F7F44@.microsoft.com...
> Hi,
> I'm new to SQL so any guidance is appreciated.
> We have 3 MS SQL based applications currently running on SBS 2003 Premium.
> As the data has grown so much, we will be purchasing a new server
> dedicated
> to SQL alone. The new server will be 64 bit capable (Xeons not Itaniums).
> Not understanding the mechanics of it all, my question is this :-
> Will the current SQL databases run without modification if we purchased
> the
> new server with 64bit Windows Server 2003 and 64bit SQL Server 2005 or are
> 32bit SQL databases not compatible with the 64bit SQL Server ?
The database itself is compatible between 32-bit and 64-bit.
So you should have no problems.
> and
> If forced to, will the database (or SQL itself) run properly if we put in
> 64
> bit Windows Server 2003 and 32 bit SQL Server 2005 ?
> Thanks.
> Kelvin
> "Hari Prasad" wrote:
>> Hi,
>> There is no difference interms of development..The major differnece is in
>> handling the memory.
>> see this link to get the capacity specs for 32 and 64 bits:-
>> http://msdn2.microsoft.com/en-us/library/ms143432.aspx
>> Thanks
>> Hari
>> SQL Server MVP
>> "Chris Ruggiero" <chris.ruggiero@.gaboing.com> wrote in message
>> news:edDAV1qxGHA.3500@.TK2MSFTNGP02.phx.gbl...
>> > Is there a difference in SQL Server 2005 64-bit versus 32-bit from a
>> > development or management point? I realize that there are differences
>> > in
>> > the hardware requirements and that there is 32-bit, X64, and IA64
>> > versions. I wanted to know if sp's, back-ups, data types, queries and
>> > functions all work and act the same.
>> >
>>