Tuesday, March 27, 2012

Consideration on SQL Server 2005 64-bit

Hi guys, I am having a new server which carrying 64-bit processor. So SQL server 2005 64-bit is needed and this is my first time to do so. Can I know is there any consideration on having a 64 bit SQL Server 2005 ?

For example,

i ) mirroring between 64 bit principal server with 32 bit mirror server ?

ii) replication between 64 bit server with 32 bit mirror server ?

Hope able to get any advices here. THank you.

Best Regards,

Hans

The On-Disk structure of databases on 32 Bit / 64 Bit is same. The database mirroring between 32 Bit - 64 Bit or 64 Bit - 32 Bit, Replication 32-64,64-32 Bit will not have any problems if configured correctly.|||

Vishal,

Can you provide some additional information regarding "if configured correctly."?

Thanks

|||The differences between 32 and 64 bit are all internal to the SQL server engine. There is no difference between setting up replication, or anything else, on 32 bit vs 64 bit.

No comments:

Post a Comment