DB Mirroring in a mixed 64bit/32bit Environment

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 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.|||Thanks very much, Ben. I guess I just skimmed the pages too fast in the BOL.
That'll teach me.
--Nick.
"Ben Nevarez" wrote:
> 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 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.