"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.

"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.