I have several satellite 32bit installations of SQL2005. I am in the process
of upgrading my main SQL server from SQL2000 to SQL2005. I what to make good
use of 32GB of RAM in this box, so I am considering the 64bit version.
One of the principal features of SQL2005 we want to leverage is DB mirroring
.
Can I mirror 32bit databases on my 32bit servers to my 64bit server and visa
versa? Does SQL2005 even care about the CPU architecture?
Thanks,
--Nick.From BOL "Prerequisites and Recommendations for Database Mirroring":
"The SQL Server on-disk storage format is the same in the 64-bit and 32-bit
environments. Therefore, a database mirroring session can combine server
instances that run in a 32-bit environment and server instances that run in
a
64-bit environment."
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"NickN" wrote:
> I have several satellite 32bit installations of SQL2005. I am in the proce
ss
> of upgrading my main SQL server from SQL2000 to SQL2005. I what to make go
od
> use of 32GB of RAM in this box, so I am considering the 64bit version.
> One of the principal features of SQL2005 we want to leverage is DB mirrori
ng.
> Can I mirror 32bit databases on my 32bit servers to my 64bit server and vi
sa
> versa? Does SQL2005 even care about the CPU architecture?
> Thanks,
> --Nick.|||Thanks very much, Ben. I guess I just skimmed the pages too fast in the BOL.
That'll teach me.
--Nick.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> From BOL "Prerequisites and Recommendations for Database Mirroring":
> "The SQL Server on-disk storage format is the same in the 64-bit and 32-bi
t
> environments. Therefore, a database mirroring session can combine server
> instances that run in a 32-bit environment and server instances that run i
n a
> 64-bit environment."
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "NickN" wrote:
>
No comments:
Post a Comment