asked
Mirror technique with SQL and Windows
Dear All, If I have the Principal Server - SQL Server2005 Enterprise - Windows Server 2008 Enterprise R2 64bit Mirror Server - SQL Server2005 Enterprise - Windows Server 2008 Enterprise R2 64bit. Witness Server - SQL Express 2005 Q1)For Mirroring technique can we use SQLServer Enterprise 32bit in Principal Server and Mirror Server ...I know the 64bit is the better choice ? Q2) A- Can we use the Windows 2003 on Witness Server or it should be Windows Server 2008? B- If the Answer for A is windows server2008 Can we use the standard 32 or 64 or Enterprise 32 or 64? Q3) For Principal and Mirror Do we need the operating system Should be the same like Enterprise - Enterprise or Enterprise - standard.
Q1 - Yes you can use Enterprise 32bit Q2 - Yes you can use Windows 2003 for the witness Q3 - Technically I think you can have differing OS, as long as the database edition matches, but practically you would want to keep them the same. The key to database mirroring is that the principal and mirror must be the same edition, and asynchronous is only supported in Enterprise Edition SP1. The witness server can be Express SP1, Workgroup SP1, Standard or Enterprise. The full list of supported operating systems is here :
http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.90%29.aspx Database Mirroring support detailed here:
http://msdn.microsoft.com/en-us/library/ms189852%28v=sql.90%29.aspx
9 People are following this question.
