SQL Server Performance

Mirroring between 64 bit SQL 2005 std and 32 bit SQL 2005 std

Discussion in 'SQL Server 2005 Database Mirroring' started by WingSzeto, Jan 16, 2008.

  1. WingSzeto Member

    We are thinking about upgrading our SQL production server to Windows 2k3 64 bit enterprise and SQL 2k5 64 bit std from SQL 2K5 32 bit std on a Windows 2K3 32 bit server. This production server is doing mirroring to another SQL 2K5 std 32 bit computer on Windows 2K3 32 bit server which we would like to leave it as it is. Is it ok to doing a mirroring between a SQL 2K5 64 bit std (the primary server) server and a SQL 2K5 32 bit (mirrored server)? If the primary server were to fail, is there any issue of switching the mirrored server to primary based on the above setup?
    Wingman
  2. MohammedU New Member

    I don't think there will be an issue. I believe it is compatible from 64 bit to 32 bit and vice versa. I didn't not test this...
  3. satya Moderator

    Theoritically it will not have any issues as the differences between 32 and 64 bit are all internal to the SQL server engine. There is no difference between setting up database mirroring, or anything else, on 32 bit vs 64 bit.
    But in realtime I have had issues when failed over to 32bit mirror server and switchign it back, it is general recommendation to have both partners with same version, mode & edition. See my presentation on SQLbits on database mirroring -http://www.sqlbits.com/Events/SQLBits_October_2007/PublicSessions.aspx fyi.

Share This Page